Make a temporary table, SELECT DISTINCT the rows from the old table to the new table, rename the old table TABLE_OLD, rename the temporary table to the original table name.
Peter <^_^> --------------------------------------------- Peter Grigor Hoobly Free Classifieds http://www.hoobly.com ----- Original Message ----- From: "Lewis Watson" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Saturday, February 15, 2003 12:30 AM Subject: Delete duplicate rows > I need to delete duplicate rows. Each row that is in the table has an > exact duplicate of itself. There are four columns. No one column could be > defined as a primary key; however, two columns together could. What's > going to be the best way to do this? > Thanks. > Lewis > > mysql, thanks > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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