56,679
社区成员
发帖
与我相关
我的任务
分享
drop procedure if exists p1;
create procedure P1()
begin
declare exit HANDLER FOR SQLSTATE '23000' insert into Error(Error_ID,Error_SQLSTATE,Error_Describe,Error_time) values(1062,'23000','键%d的重复条目',now());
declare exit HANDLER FOR SQLSTATE '21S01' insert into Error(Error_ID,Error_SQLSTATE,Error_Describe,Error_time) values(1136,'21S01','列计数不匹配行%ld上的值计数',now());
rollback;
start transaction;
insert into ta values(6,'张三',now());
insert into ta values(7,'李四',now());
commit;
end;