Re: The age old delete duplicates

2005-05-05 Thread Rhino
- Original Message - From: "Scott Haneda" <[EMAIL PROTECTED]> To: "MySql" Sent: Thursday, May 05, 2005 3:39 AM Subject: The age old delete duplicates > I have been researching on how to deal with duplicate data. While I have a > case where there can

Re: The age old delete duplicates

2005-05-05 Thread Scott Haneda
on 5/5/05 2:52 AM, Jigal van Hemert at [EMAIL PROTECTED] wrote: > - Original Message - > From: "Scott Haneda" >> on 5/5/05 2:11 AM, Joerg Bruehe at [EMAIL PROTECTED] wrote: >> Basically, I have a chopping cart, this one is a little weird, for reasons >> not worth explaining, you have a car

Re: The age old delete duplicates

2005-05-05 Thread Jigal van Hemert
- Original Message - From: "Scott Haneda" > on 5/5/05 2:11 AM, Joerg Bruehe at [EMAIL PROTECTED] wrote: > Basically, I have a chopping cart, this one is a little weird, for reasons > not worth explaining, you have a cart when a user is not logged in, and they > *may* have one they made at s

Re: The age old delete duplicates

2005-05-05 Thread Scott Haneda
on 5/5/05 2:11 AM, Joerg Bruehe at [EMAIL PROTECTED] wrote: > Hi Scott, all! > > Scott Haneda wrote: >> I have been researching on how to deal with duplicate data. [[...]] >> >> I am not in a situation where I can test for duplicates on insert, so the on >> duplicate key update deal does me no

Re: The age old delete duplicates

2005-05-05 Thread Joerg Bruehe
Hi Scott, all! Scott Haneda wrote: I have been researching on how to deal with duplicate data. [[...]] I am not in a situation where I can test for duplicates on insert, so the on duplicate key update deal does me no good here. Most data points to selecting distinct records to a temp table, deleti

The age old delete duplicates

2005-05-05 Thread Scott Haneda
I have been researching on how to deal with duplicate data. While I have a case where there can be duplicate data, and I want to get rid of it, the general ideas I seem to find are as follows, plus my own, which I would like opinions on since I have not seen it mentioned. I am not in a situation