同样创建数据库表:
create table mysequence
(
Id bigint not null auto_increment;
);
创建一个函数:
DELIMITER$$
Drop function if exists `mysequence.nextval`$$
create function ` mysequence.nextval`()
RETURNS bigint
NOT DETERMINISTIC
READS SQL DATA
BEGIN
insert mysequence values( NULL );
delete from mysequence;
return LAST_INSERT_ID();
END
$$
DELIMITER ;