Re: MySQL - check for existing data

2002-03-16 Thread Geoff Quelch
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

Re: MySQL - check for existing data

2002-03-16 Thread Fournier Jocelyn [Presence-PC]
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