mysql 保存增加序列号

-- 创建一个包含自增字段的表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE
);

-- 插入数据
INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');
INSERT INTO users (name, email) VALUES ('Bob', 'bob@example.com');

-- 查询数据
SELECT * FROM users;

-- 创建一个序列号管理表
CREATE TABLE sequence (
    seq_name VARCHAR(50) PRIMARY KEY,
    next_val BIGINT NOT NULL
);

-- 初始化序列号
INSERT INTO sequence (seq_name, next_val) VALUES ('user_seq', 1);

-- 获取下一个序列号
DELIMITER $$
CREATE FUNCTION getNextSequence(seq_name VARCHAR(50)) RETURNS BIGINT
BEGIN
    DECLARE next_val BIGINT;
    UPDATE sequence SET next_val = next_val + 1 WHERE seq_name = seq_name;
    SELECT next_val INTO next_val FROM sequence WHERE seq_name = seq_name;
    RETURN next_val;
END$$
DELIMITER ;

-- 使用序列号插入数据
INSERT INTO users (id, name, email) VALUES (getNextSequence('user_seq'), 'Charlie', 'charlie@example.com');