Re: deleting duplicates from table

[Wesley Furgiuele]

I think one way to solve it would be to move your data to a new copy of 
your table.  Assuming record_ref and keyword are separate fields...

CREATE TABLE newtable SELECT * FROM oldtable GROUP BY CONCAT( 
record_ref, keyword );

Wes
On Jul 16, 2004, at 7:08 PM, L a n a wrote:
Hello,
I'm trying to solve a task in Mysql 4:
I have a table
rec_id | record_ref | keyword
******************************
1        |              2| apple
2        |              2|orange
3        |              2|apple
4        |              3|mango
******************************
How can I delete records where pair (record_ref and keyword) are 
identical? In this case either record #1 or #3, but not both.

Thank you,
Lana

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]