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;

ALTER TABLE users MODIFY COLUMN id BIGINT AUTO_INCREMENT;