mysql自动增长

ALTER TABLE table_name AUTO_INCREMENT = 100;

ALTER TABLE table_name MODIFY column_name BIGINT AUTO_INCREMENT = 1;

-- 创建一个序列表
CREATE TABLE sequence_table (
    seq_name VARCHAR(50) NOT NULL,
    current_val INT NOT NULL,
    PRIMARY KEY (seq_name)
);

-- 插入初始值
INSERT INTO sequence_table (seq_name, current_val) VALUES ('user_seq', 1);

-- 创建存储过程来获取下一个序列值
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 ;

-- 使用存储过程插入数据
DELIMITER //
CREATE PROCEDURE insert_user(IN user_name VARCHAR(50))
BEGIN
    DECLARE next_id INT;
    CALL nextval('user_seq', next_id);
    INSERT INTO users (id, name) VALUES (next_id, user_name);
END //
DELIMITER ;