I have a table in which I want to eliminate duplicates, where I define
a duplicate to be any two rows with the same values on field1 and
field2
This gives me the sort I want
SELECT * FROM this_table ORDER BY name, time;
But in addition I would like to drop duplicates.
Is there a way to modify the table in place to remove the duplicates?
If not, how do I create a temporary table with duplicates suppressed,
and then rename/copy this table to the original table name?
Thanks,
John Hunter
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
