oracle数据库转mysql数据库

oracle转mysql时，mysql没有oracle特有的序列

新建表

create table SS_SEQS(

 idval int unsigned,

 primary key (idval)

) engine=InnoDB;

 

Insert into SS_SEQS values(10000);

新建立函数

delimiter $$

create function SS_SEQS_nextval()

returns integer

contains SQL

begin

declare id long;

update SS_SEQS set idval=last_insert_id(idval+1);

select last_insert_id() into id;

if(id=99999) then

update SS_SEQS set idval=9999;

end if;

return id;

end;

$$

delimiter ;

得到序列值

select SS_SEQS_nextval();

参考地址：https://blog.csdn.net/lele2426/article/details/7487525