我就写了个最简单的,发现老是报错,不知道是default-storage-engine=INNODB不支持事务,还是我代码写得有问题,希望,各位能帮忙看下,谢谢。
代码如下: BEGIN
START TRANSACTION;
delete from TUserRights where userNo = N'b'; insert into TUserRights(userNo,rightsNo) values(N'b',N'1001');
COMMIT;
END;
错误信息如下:
[SQL] BEGIN
START TRANSACTION;
[Err] 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 'START TRANSACTION' at line 2
代码如下: BEGIN
START TRANSACTION;
delete from TUserRights where userNo = N'b'; insert into TUserRights(userNo,rightsNo) values(N'b',N'1001');
COMMIT;
END;
错误信息如下:
[SQL] BEGIN
START TRANSACTION;
[Err] 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 'START TRANSACTION' at line 2
create procedure sp_test()
begin
START TRANSACTION;
delete from TUserRights where userNo = N'b'; insert into TUserRights(userNo,rightsNo) values(N'b',N'1001');
COMMIT; end
$delimiter ;
call sp_test();