華閱文章網mysql怎么一次執行多條SQL語句
mysql_query不支持同時運行多條SQL。你要以；號拆開分別執行
mysql_query("SELECT @a:=id FROM csdn order by id asc limit 30,1");
mysql_query("SELECT @b:=id FROM csdn order by id asc limit 60,1");
mysql_query("SELECT * from csdn where id>@a and id<@b");
mysql查詢語句 多條合并
最笨的方式就是把這么多條查詢結果當成表，然后select全部，雖然笛卡爾積，但是每個查詢都只有一條記錄。
select * from
(select count(*)as A1 from KJ_KJHDRYMXB t1 where * = 'a部' ）a,
(select count(*)AS A2 from KJ_KJHDRYMXB t2 where * = '項目人員' and * = 'a部'）b,
(select count(*)AS A3 from KJ_KJHDRYMXB t3 where (* = '服務人員'or * = '管理人員') and * = 'a部'）c,
(select count(*)AS A4 from KJ_KJHDRYMXB t31 where * = '女' and * = 'a部'）d
(select count(*)AS A5 from KJ_KJHDRYMXB t4 where (* = '高級職稱'or * = '中級職稱')and * = 'a部'）d,
(select count(*)AS A6 from KJ_KJHDRYMXB t5 where * = 'a部'）e
(select count(*)AS A7 from KJ_KJHDRYMXB t6 where * = '博士'and * = 'a部'）f
(select count(*)AS A8 from KJ_KJHDRYMXB t7 where * = '碩士' and * = 'a部'）g
(select count(*)AS A9 from KJ_KJHDRYMXB t8 where * = '本科'and * = 'a部'）h
