You are here: Re: How to enforce an ENUM ? « PHP SQL « IT news, forums, messages
Re: How to enforce an ENUM ?

Posted by ZeldorBlat on 09/14/07 14:24

On Sep 14, 6:50 am, Pugi! <pugin...@gmail.com> wrote:
> I have a table with an ENUM row.
> If I insert a new row (using PHP5, MySQL5 and PDO for database
> connections) with a value that is not in the ENUM list, no error, no
> warning, no exception ... The row is inserted but the field where
> normally one of the values of the ENUM list should be is empty even if
> it is NOT NULL.
>
> How can I enforce the ENUM ?
>
> Pugi!

I looked in the manual for you and found this information:

<http://dev.mysql.com/doc/refman/5.0/en/constraint-enum.html>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация