mysql 多條語句,怎么判斷其中一條執行錯誤,就執行回滾
寫一個存儲過程,在存儲過程里寫一個事物,再把你要的mysql 多條語句寫在事物里面就行了,要用的時候調用一下存儲過程.大致格式是這樣的:drop procedure if exists accessCount; delimiter $create procedure accessCount()BEGIN DECLARE t_error INTEGER DEFAULT 0;/*設置錯誤增量*/ DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1; START TRANSACTION;/*開啟事物*/xxxx(你的語句)IF t_error = 1 THEN /*執行失敗回滾*/ROLLBACK; ELSE COMMIT; END IF;end $delimiter ;。
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
轉載請注明出處華閱文章網 » mysqlifthen多條語句