On Saturday 16 March 2002 03:14 pm, you said:
> Hi,
>
> Just set a unique index on the right column and you won't have anymore
> duplicate in your table :)
>
> ALTER TABLE yourtable ADD UNIQUE(your_column);
>
> Regards,
>
You might also want to use "REPLACE INTO ..." rather than "INSERT INTO..." a
Hi,
Just set a unique index on the right column and you won't have anymore
duplicate in your table :)
ALTER TABLE yourtable ADD UNIQUE(your_column);
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Craig Westerman" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED