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

no duplicate entries..

2003-07-20 Thread harsh
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. thanks for any reply . harsh --