nextval

CREATE DEFINER=`abac`@`%` FUNCTION `nextval`(
    `seq_name` varchar(100)
)
RETURNS bigint(20)
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN

DECLARE cur_val bigint(20);
SELECT
sequence_cur_value INTO cur_val

FROM

sequence_data

WHERE
sequence_name = seq_name
;

IF cur_val IS NOT NULL THEN
UPDATE
sequence_data
SET
sequence_cur_value = IF (
(sequence_cur_value + sequence_increment) > sequence_max_value,
IF (
sequence_cycle = TRUE,
sequence_min_value,
NULL
),
sequence_cur_value + sequence_increment
)

wHERE

sequence_name = seq_name
;

END IF;
RETURN cur_val;

END