create procedure selectdemo_user()
begin
select * from demo_user;
end;
create procedure delldemo_user()
begin
delete from demo_user where id in (select id from demo_user) ;
end ;
drop procedure delldemo_user
create procedure emptyUser()
begin
delete from demo_user where id > 0;
end
call emptyUser();
call delldemo_user();
call selectdemo_user();
set autocommit =0;
delete from demo_user where id=200000021
savepoint p1;
delete from demo_user where id=200000020
savepoint p2;
rollback;
rollback to p1;
rollback to p2;
set autocommit=1;
begin
select * from demo_user;
end;
create procedure delldemo_user()
begin
delete from demo_user where id in (select id from demo_user) ;
end ;
drop procedure delldemo_user
create procedure emptyUser()
begin
delete from demo_user where id > 0;
end
call emptyUser();
call delldemo_user();
call selectdemo_user();
set autocommit =0;
delete from demo_user where id=200000021
savepoint p1;
delete from demo_user where id=200000020
savepoint p2;
rollback;
rollback to p1;
rollback to p2;
set autocommit=1;