设置已存在序列的nextval的方法
转自:http://www.itpub.net/thread-253222-1-1.html
1. 删掉重建,重建时指定start with 20
2. 做一个循环, 循环执行select nextval 19次
3.
Alter sequence mysq increment by 19;
select mysq.nextval from dual;
Alter sequence mysq increment by 1;
转自:http://www.itpub.net/thread-253222-1-1.html
1. 删掉重建,重建时指定start with 20
2. 做一个循环, 循环执行select nextval 19次
3.
Alter sequence mysq increment by 19;
select mysq.nextval from dual;
Alter sequence mysq increment by 1;