mysql事务封装
我想把增删改查的事务提交封装在sql事务中,不想用程序的事务,应该如何封装呢,能否给出范例代码。
下面是我尝试封装的代码
BEGIN
DECLARE t_error INTEGER;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error = 1;
START TRANSACTION;
insert into kehu(kehu_guid)values('e9f045c7-7988-4cbf-9ae0-b9920753e619');
insert into kehu(kehu_guid)values('e9f045c7-7988-4cbf-9ae0-b9920753e618');
IF t_error = 1 THEN
ROLLBACK;
ELSE
COMMIT;
END IF;
END
提示不正确。
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE t_error INTEGER' at line 2