mysql仿sequence实现主键增长

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//