A simple way to remove duplicate rows in a table _php tutorial

First create a table that is the same as the original table.
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 table data, simple

http://www.bkjia.com/PHPjc/631024.html www.bkjia.com true http://www.bkjia.com/PHPjc/631024.html techarticle 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 After importing the original ...

