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