CREATE TABLE `TBL_SEQUENCE` (
`sequence_name` varchar(64) NOT NULL COMMENT '序列名称' ,
`value` bigint NOT NULL DEFAULT 0 COMMENT '当前值' ,
PRIMARY KEY (`sequence_name`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
DELIMITER //
CREATE FUNCTION NEXT_VAL_TEST(sequence_name varchar(64))
RETURNS bigint
BEGIN
declare current_val bigint;
set current_val = 0;
select t.value into current_val from TBL_SEQUENCE t where t.sequence_name = sequence_name for update;
update TBL_SEQUENCE t set t.value = t.value + 1 where t.sequence_name = sequence_name;
return current_val + 1;
END//
DELIMITER ;
DELIMITER //
CREATE FUNCTION NEXT_VAL(sequence_name VARCHAR(64))
RETURNS BIGINT
BEGIN
UPDATE TBL_SEQUENCE_1 t, (SELECT @current_val:=`value` FROM TBL_SEQUENCE_1 t2 WHERE t2.sequence_name=sequence_name) t3 SET t.value = t.value + 1 WHERE t.sequence_name =sequence_name AND @current_val=t.value;
RETURN @current_val+1;
END//