Hi Nathan, you can use a group by, like this:
select <all_columns> from table group by <all_columns> Put this result in a separate table, delete the data from the old table and put the the merged rows from the separate table into it. I tried using a DELETE with a subquery and a group-by, but MySql is not capable of handling this. -- Peter Sap ----- Original Message ----- From: "Nathan Jones" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 4:16 AM Subject: Merging duplicate rows > How do you merge duplicate rows? All rows involved contain identical data > in each column. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]