Re: Delete duplicate rows

2003-02-15 Thread Peter Grigor
- 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

Re: Delete duplicate rows

2003-02-15 Thread Paul DuBois
At 23:30 -0600 2/14/03, Lewis Watson wrote: 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

Delete duplicate rows

2003-02-14 Thread Lewis Watson
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