29 lines
691 B
Plaintext
29 lines
691 B
Plaintext
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@'%';
|