本人从未用过mysql数据库,
今日想实现在Mysql中创建一个存储过程,有参数,sql语句为2条insert语句,需要用到事务。
望各位大虾回复?
示例:
create procedure ff()
begin
declare exit handler for sqlexception rollback;
start transaction;
insert into ....;
insert into ....;
commit;
end;
示例:
delimiter $$
create procedure ff()
begin
declare exit handler for sqlexception rollback;
start transaction;
insert into ....;
insert into ....;
commit;
end;$$
delimiter ;