mysql的序号递增不连续

TRUNCATE TABLE your_table_name;

ALTER TABLE your_table_name AUTO_INCREMENT = 1;

CREATE TABLE sequence (
    seq_name VARCHAR(50) NOT NULL,
    current_val INT NOT NULL,
    increment INT NOT NULL DEFAULT 1,
    PRIMARY KEY (seq_name)
);

INSERT INTO sequence (seq_name, current_val, increment) VALUES ('your_seq_name', 1, 1);

SELECT @next_val := current_val + increment FROM sequence WHERE seq_name = 'your_seq_name' FOR UPDATE;
UPDATE sequence SET current_val = @next_val WHERE seq_name = 'your_seq_name';

INSERT INTO your_table_name (id, column1, column2) VALUES (@next_val, 'value1', 'value2');

DELIMITER //

CREATE PROCEDURE generate_id(IN table_name VARCHAR(50), OUT next_id INT)
BEGIN
    DECLARE current_id INT;
    SET current_id = (SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = table_name);
    SET next_id = current_id;
END //

DELIMITER ;

CALL generate_id('your_table_name', @next_id);
SELECT @next_id;