mysql 修改主键变为1

CREATE TABLE new_table (
    new_id INT PRIMARY KEY,
    column1 datatype,
    column2 datatype,
    ...
);

INSERT INTO new_table (new_id, column1, column2, ...)
SELECT id, column1, column2, ...
FROM old_table;

DROP TABLE old_table;

RENAME TABLE new_table TO old_table;

START TRANSACTION;
CREATE TABLE new_table (
    new_id INT PRIMARY KEY,
    column1 datatype,
    column2 datatype,
    ...
);
INSERT INTO new_table (new_id, column1, column2, ...)
SELECT id, column1, column2, ...
FROM old_table;
DROP TABLE old_table;
RENAME TABLE new_table TO old_table;
COMMIT;

INSERT INTO new_table (new_id, column1, column2, ...)
SELECT id, column1, column2, ...
FROM old_table
ON DUPLICATE KEY UPDATE column1=VALUES(column1), column2=VALUES(column2);