--创建序列表
CREATE TABLE IF NOT EXISTS `sequence` (
`name` varchar(50) NOT NULL,
`current_value` int(11) NOT NULL,
`increment` int(11) NOT NULL DEFAULT '1'
);
INSERT INTO `sequence` (`name`, `current_value`, `increment`) VALUES ('s_blog_account', 0, 1) ;
--创建取当前值的函数
DROP FUNCTION IF EXISTS `currval`;
CREATE FUNCTION `currval`(seq_name VARCHAR(50)) RETURNS int(11)
READS SQL DATA
DETERMINISTIC
BEGIN
DECLARE VALUE INTEGER;
SET VALUE = 0;
SELECT current_value INTO VALUE FROM sequence WHERE NAME = seq_name;
RETURN VALUE;
END;
--创建取下一个值的函数
DROP FUNCTION IF EXISTS `nextval`;
CREATE FUNCTION `nextval`(seq_name VARCHAR(50)) RETURNS int(11)
DETERMINISTIC
BEGIN
UPDATE sequence SET current_value = current_value + increment WHERE NAME = seq_name;
RETURN currval(seq_name);
END
;
--获取下一个序列值
select nextval("s_blog_account") from dual;