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).
>
> Or does one need to do the validation before inserting info?
>
> Jari Mäkelä
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Regards
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
