设置已存在序列的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;

posted @ 2011-09-14 10:05  爱上飞飞的面码  阅读(466)  评论(0编辑  收藏  举报