On 10 Apr 2002, at 12:16, Jeffrey Flowers wrote:
> Perhaps having a column in my
> database with a serialized, unique record number would be a way to prevent
> this in the future?
That would allow you to delete just one of the duplicates (which you
also do with LIMIT 1 on your DELETE query), bu
>You are 100% correct.
>
>Since MySQL does not support "cursors", I always
>put an auto_increment column in my tables for just
>this purpose.
>
>(This is what other DBMS' do, they just do it behind
>your back)
You're right. I use DBase IV at work and every record has an internal record
number.
>
You are 100% correct.
Since MySQL does not support "cursors", I always put an auto_increment
column in my tables for just this purpose.
(This is what other DBMS' do, they just do it behind your back)
Unfortunately, the way MySQL really handles result sets doesn't lend itself
to simply adding
