Re: Identical entries

2002-10-31 Thread Alec . Cawley
> I have a database which has identical entries. Is there > a way to tell mySQL to throw out duplicate entires > when un insert/update is done via ColdFusion? Tell mySQL that the columns are UNIQUE. Alec - Before po

Re: Identical entries

2002-10-31 Thread Joseph Bueno
Create an unique index. See: http://www.mysql.com/doc/en/CREATE_INDEX.html Regards, Joseph Bueno FlashGuy wrote: > Hi, > > I have a database which has identical entries. Is there a way to tell > mySQL to throw out duplicate entires when un insert/update is done via > ColdFusion? > > > --