如何根据列的顺序添加自动增量主键？

CREATE TABLE table_name (
    id INT AUTO_INCREMENT PRIMARY KEY,
    column1 data_type,
    column2 data_type,
    ...
);

ALTER TABLE table_name MODIFY id INT AUTO_INCREMENT PRIMARY KEY;

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name';

ALTER TABLE table_name AUTO_INCREMENT = value;