DaniWeb IT Discussion Community - View Single Post

Re: Remov duplicates from array

Dec 5th, 2008

There is way to remove duplicate data or row like...
Step 1: Move the non duplicates (unique tuples) into a temporary table

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
CREATE TABLE new_table AS
SELECT * FROM old_table WHERE 1 GROUP BY [COLUMN TO remove duplicates BY];
CREATE TABLE new_table AS
SELECT * FROM old_table WHERE 1 GROUP BY [COLUMN TO remove duplicates BY];

Step 2: delete delete the old table

Help with Code Tags

PHP Syntax (Toggle Plain Text)

DROP TABLE old_table;

Step 3: rename the new_table to the name of the old_table

Help with Code Tags

PHP Syntax (Toggle Plain Text)

RENAME TABLE new_table TO old_table;