创建序列:
create sequence mysql;
查询序列:
select * from user_sequences;
插入序列:
insert into member(mid,name)values(mysql.nextval,'A');
删除序列:
drop sequence mysql;
序列步长默认增长是1,设置为步长为3:
create sequence mysql increment by 3;
设置步长为3,以30开始:
create sequence mysql increment by 3 start with 30;