Hi. On Thu, May 02, 2002 at 08:13:26AM +0200, [EMAIL PROTECTED] wrote: > No i don't mean that, i mean a field that the user can assign a value to > it or not (optional) or a field that the user must set a value for it > (Mandatory) .
That is exactly what I understood you want. Either I misunderstood you again or you are missing my point. With MySQL, to get a field mandatory, you must not allow NULL values (therefore "NOT NULL) and forbid to use the DEFAULT value, if no value is assigned (that is what DONT_USE_DEFAULT_FIELDS is for). Then, and only then, MySQL will generate an error if field is left out on an INSERT. If I misunderstood you, you should elaborate by an full example, including what you get (falsely) and what you would expect. Regards, Benjamin. [...] > >If you mean that you want a query to fail, if a specific field is not > >specifed, you to declare the columns NOT NULL and have to compile > >mysqld with DONT_USE_DEFAULT_FIELDS as explained here: > >http://www.mysql.com/doc/I/N/INSERT.html and > >http://www.mysql.com/doc/c/o/configure_options.html -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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