mysql设置id起始值

CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    age INT
) AUTO_INCREMENT = 100;

ALTER TABLE example_table AUTO_INCREMENT = 200;

-- 创建表并设置自增列的起始值
CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    age INT
) AUTO_INCREMENT = 100;

-- 插入数据
INSERT INTO example_table (name, age) VALUES ('Alice', 25);
INSERT INTO example_table (name, age) VALUES ('Bob', 30);

-- 查看数据
SELECT * FROM example_table;

-- 修改自增列的起始值
ALTER TABLE example_table AUTO_INCREMENT = 200;

-- 再次插入数据
INSERT INTO example_table (name, age) VALUES ('Charlie', 35);

-- 查看数据
SELECT * FROM example_table;