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
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
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