Hi. On Tue, Apr 30, 2002 at 03:31:25PM +0200, [EMAIL PROTECTED] wrote: > Dear Sir > > I want to ask how can i assign a field as mandatory and other as > optional using the Mysql Database.
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 Bye, Benjamin. -- [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