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

Re: Delete duplicate rows

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

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, t