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