A simple method to delete duplicate rows in a table_PHP tutorial

First create a table that is the same as the original table,
and then create an ignore_dup_key index on the table, as follows:
CREATE UNIQUE INDEX removedups
ON 　#table_copy (name)
WITH IGNORE_DUP_KEY
Then import Original table data, keep it simple

http://www.bkjia.com/PHPjc/631024.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631024.htmlTechArticleFirst create a table that is the same as the original table, and then create the ignore_dup_key index on the table, as follows: CREATE UNIQUE INDEX removedups ON #table_copy (name) WITH IGNORE_DUP_KEY Then import the original...