START TRANSACTION;
Select @ErrorCount=0; insert into attrecord(UserId,UserName,IpAdd,AttTime,AttState,Verificationmode) values (11167, '' , '192.168.80.180','2011-9-26 14:53:45','0','指纹'); Select @ErrorCounts=@@ROWCOUNT
if @ErrorCounts=0
begin Select @ErrorCount=@ErrorCount+1 end
if @ErrorCount>0
begin rollback transaction select 0; end
else begin commit transaction select 1; end
这个语句运行有错误 要怎么改 mysql中
Select @ErrorCount=0; insert into attrecord(UserId,UserName,IpAdd,AttTime,AttState,Verificationmode) values (11167, '' , '192.168.80.180','2011-9-26 14:53:45','0','指纹'); Select @ErrorCounts=@@ROWCOUNT
if @ErrorCounts=0
begin Select @ErrorCount=@ErrorCount+1 end
if @ErrorCount>0
begin rollback transaction select 0; end
else begin commit transaction select 1; end
这个语句运行有错误 要怎么改 mysql中
start transaction;
insert into attrecord(UserId,UserName,IpAdd,AttTime,AttState,Verificationmode) values (11167, '' , '192.168.80.180','2011-9-26 14:53:45','0','指纹');
if ROW_COUNT()=1
begin
select 0;
rollback
end
else
begin
commit;
select 1;
end