1、创建表tb_sequence,用来存放sequence值:
create table tb_sequence(name varchar(50) not null,current_value int not null,_increment int not null default 1, primary key(name));
2.现在插入一条记录
insert into tb_sequence values('seqentrustno',1,1);
3. 定义函数_nextval:
DELIMITER//
createfunction _nextval(n varchar(50)) returns integer
begin
declare_cur int;
set_cur=(select current_value from tb_sequence where name= n);
updatetb_sequence
set current_value = _cur + _increment
where name=n ;
return_cur;
end;
//
4、进行seqentrustno的查找。
select _nextval('seqentrustno');