procedure autocommit savepoint

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;