mysql数据库中创建序列

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50)
);

DELIMITER //

CREATE PROCEDURE create_sequence(IN sequence_name VARCHAR(50), OUT next_value INT)
BEGIN
    DECLARE current_value INT;

    -- 获取当前序列值
    SELECT sequence_value INTO current_value
    FROM sequences
    WHERE name = sequence_name;

    -- 增加序列值
    SET next_value = current_value + 1;

    -- 更新序列表
    UPDATE sequences
    SET sequence_value = next_value
    WHERE name = sequence_name;
END //

DELIMITER ;

CREATE TABLE sequences (
    name VARCHAR(50) PRIMARY KEY,
    sequence_value INT
);

-- 初始化序列值
INSERT INTO sequences (name, sequence_value)
VALUES ('my_sequence', 0);

CALL create_sequence('my_sequence', @next_value);
SELECT @next_value;