mysql序列重新开始

ALTER TABLE your_table_name AUTO_INCREMENT = 1;

ALTER TABLE users AUTO_INCREMENT = 1;

DROP TABLE your_table_name;
CREATE TABLE your_table_name (
    id INT AUTO_INCREMENT PRIMARY KEY,
    ...
);

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

DELIMITER //

CREATE FUNCTION generate_sequence()
RETURNS INT
DETERMINISTIC
BEGIN
    DECLARE current_value INT;
    SELECT AUTO_INCREMENT INTO current_value FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'your_database_name' AND TABLE_NAME = 'your_table_name';
    RETURN current_value;
END //

DELIMITER ;

INSERT INTO your_table_name (id, name, email) VALUES (generate_sequence(), 'John Doe', 'john@example.com');