mysql插入自增列语句

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

INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');
INSERT INTO users (name, email) VALUES ('Bob', 'bob@example.com');

SELECT * FROM users;

+----+-------+-----------------+
| id | name  | email           |
+----+-------+-----------------+
|  1 | Alice | alice@example.com|
|  2 | Bob   | bob@example.com |
+----+-------+-----------------+

ALTER TABLE users AUTO_INCREMENT = 1;

START TRANSACTION;
INSERT INTO users (name, email) VALUES ('Charlie', 'charlie@example.com');
COMMIT;

ALTER TABLE users MODIFY COLUMN id BIGINT AUTO_INCREMENT;