Re: no duplicate entries..

2003-07-21 Thread Victoria Reznichenko
harsh <[EMAIL PROTECTED]> wrote: > > Hi all, > How do i do this ? > i have a table with one of the column named uid, > Now i want to insert a new row,only if no other > row exist with the uid i m trying to insert. > I hope its clear. Define column as a PRIMARY or UNIQUE key and use INSERT IGNORE:

Re: no duplicate entries..

2003-07-20 Thread Tan Shao Yi
On Sun, 20 Jul 2003, harsh wrote: > > Hi all, > How do i do this ? > i have a table with one of the column named uid, > Now i want to insert a new row,only if no other > row exist with the uid i m trying to insert. > I hope its clear. Hello Harsh, How about making the uid column in your table a