如何删除MySQL表中的重复项

CREATE TABLE new_table_name LIKE original_table_name;

INSERT INTO new_table_name (column1, column2, column3, ...)
SELECT DISTINCT column1, column2, column3, ...
FROM original_table_name;

DROP TABLE original_table_name;

RENAME TABLE new_table_name TO original_table_name;