Re: No identical entries in a field

2001-06-12 Thread Hannes Niedner
On 6/11/01 11:11 PM, "Jari Mäkelä" <[EMAIL PROTECTED]> wrote: > Hi, > > how a field ( names of products ) of database should be defined so that you > could not enter identical entries at the field? > > Or does one need to do the validation before inserting info? > > Jari Mäkelä > How about cr

Re: No identical entries in a field

2001-06-12 Thread Joseph Bueno
Hi, Jari Mäkelä wrote: > > Hi, > > how a field ( names of products ) of database should be defined so that you > could not enter identical entries at the field? If you create an 'UNIQUE INDEX' on that field, mysql will not allow you to enter duplicate values (you will get "duplicate key" error

No identical entries in a field

2001-06-11 Thread Jari Mäkelä
Hi, how a field ( names of products ) of database should be defined so that you could not enter identical entries at the field? Or does one need to do the validation before inserting info? Jari Mäkelä - Before posting, pleas