mysql事务高级_mysql高级 标量 与事务

declare @sum int; -- 等价于java中的 int a = 0 声明一个变量而已

declare @i int;

select @sum =0,@i = 0;

while @i <= 100

begin

set @sum = @sum + @i;

set @i = @i+1;

end;

select @sum;

事务：

begin transaction -- 开启事务

declare @myError int;

set @myError = 0;

insert into dbo.test1 (id,name) values(3,'1'),(4,'22');

set @myError = @myError + @@ERROR;

insert into dbo.test1 (id,name) values(5,'1'),(6,'22');

set @myError = @myError + @@ERROR;

if @myError > 0

begin

rollback transaction

end

else

begin

commit transaction;

end;

--第二种用法

begin transaction -- 开启事务

begin try

insert into dbo.test1 (id,name) values(3,'1111'),(4,'2211');

insert into dbo.test1 (id,name) values(5,'1'),(6,'22');

commit transaction;

end try

begin catch

rollback transaction

end catch;