create database s_db;
create user normal_1@'%' identified by 'pass';
create user normal_2@'%' identified by 'pass';
grant all on s_db.* to normal_1@'%' ;
grant all on s_db.* to normal_2@'%' ;
####################################
1.test batch and skip when first call.
####################################
use s_db;
create sequence s1 start with 1 maxvalue 10 increment by 1 nocache;
select nextval(s1);
nextval(s1)
1
select currval(s1);
currval(s1)
1
drop sequence s1;
create sequence s1 start with 1 maxvalue 10 increment by 1 nocache;
select nextval(s1);
nextval(s1)
1
select currval(s1);
currval(s1)
1
drop sequence s1;
drop database s_db;
drop user normal_1@'%';
drop user normal_2@'%';