How to replace id for all records in a table?

Question

MySQL

Good day!

SELECT ID, COUNT(ID) AS c FROM wp_posts GROUP BY ID HAVING c > 1

Shows me that I have 106 entries with id 0, how can I bring all the entries back to normal? do the numbering

This must be done to put the auto_increment primary key on the table. And while the DB gives me an error:

#1062 - ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '6168' for key 'PRIMARY'

When I try to enable auto_increment through the table structure.

Answer 1

Found a solution in one of the questions. It helped, everything worked.

CREATE table wp_posts_copy LIKE wp_posts; 
ALTER TABLE wp_posts_copy ADD PRIMARY KEY (id); 
INSERT IGNORE INTO wp_posts_copy SELECT * FROM wp_posts; -- INSERT INGORE вставит только по одному экземпляру id. 
DROP TABLE wp_posts; 
RENAME TABLE wp_posts_copy TO wp_posts;