查看mysql 获取序列

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

INSERT INTO users (name) VALUES ('Alice');
INSERT INTO users (name) VALUES ('Bob');

SELECT * FROM users;

CREATE TABLE sequence_table (
    seq_name VARCHAR(50) PRIMARY KEY,
    current_val INT NOT NULL
);

INSERT INTO sequence_table (seq_name, current_val) VALUES ('user_seq', 0);

DELIMITER //

CREATE PROCEDURE nextval (IN seq_name VARCHAR(50), OUT next_val INT)
BEGIN
    UPDATE sequence_table SET current_val = current_val + 1 WHERE seq_name = seq_name;
    SELECT current_val INTO next_val FROM sequence_table WHERE seq_name = seq_name;
END //

DELIMITER ;

CALL nextval('user_seq', @next_val);
SELECT @next_val;

START TRANSACTION;
INSERT INTO users (name) VALUES ('Charlie');
COMMIT;

-- 批量更新序列值
UPDATE sequence_table SET current_val = current_val + 100 WHERE seq_name = 'user_seq';