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;