MYSQL Remove Duplicate
Posted: Tue Jun 08, 2010 11:31 am
Hey there,
I have a function to remove the duplicate in one of my table but I cant seem to be able to ORDER the way mysql select the values.
Here is my initial table:
I want to remove the duplicated URL and make sure that it keeps only the value with the higher PR. I tried using the ORDER BY attribute but it doesnt seem to work. The first 3 values with a PR of 0 are always selected and placed in the new table...
The good result should be that the 3 values (a,b,c) with a PR of 6 are found in the final table.
I tried this and it doesnt work:
Thanks!
I have a function to remove the duplicate in one of my table but I cant seem to be able to ORDER the way mysql select the values.
Here is my initial table:

Code: Select all
mysql_query("CREATE TABLE new_table as SELECT * FROM test GROUP BY url")
mysql_query("DROP TABLE test")
mysql_query("RENAME TABLE new_table TO test")
The good result should be that the 3 values (a,b,c) with a PR of 6 are found in the final table.
I tried this and it doesnt work:
Code: Select all
mysql_query("CREATE TABLE new_table as SELECT * FROM test GROUP BY url ORDER BY pr DESC")