insert into user(col1,col2...) values(id,username,userpwd,now(),0); insert into userdetails(col1,col2...) values(id,'',0,now(),0,''); insert into userbbs(col1,col2...) values(id,0,0,0,0,0,now(),'','',0,0); insert into userworkexperience(col1,col2...) values(now(),'',id);end
开始事务。
insert into user(col1,col2...) values(id,username,userpwd,now(),0);
insert into userdetails(col1,col2...) values(id,'',0,now(),0,'');
insert into userbbs(col1,col2...) values(id,0,0,0,0,0,now(),'','',0,0);
insert into userworkexperience(col1,col2...) values(now(),'',id);end
我要的是捕捉错误然后rollback
如果只是开始事务结束事务 在一些代码执行的时候会吧没有出错的代码运行.
DECLARE type HANDLER FOR condition1,condition2,......,commond
我知道各位都是高手.
我初学 才开始用PHP实在对MYSQL一窍不通.
补全给分.谢谢
create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;
PREPARE stmt_name FROM SqlCMD1;
EXECUTE stmt_name;
DEALLOCATE stmt_name;
PREPARE stmt_name FROM SqlCMD2;
EXECUTE stmt_name;
DEALLOCATE stmt_name;
PREPARE stmt_name FROM SqlCMD3;
EXECUTE stmt_name;
DEALLOCATE stmt_name;
COMMIT;
end#drop PROCEDURE aa