DEpending on the table layouts you can use NOT NULL, UNIQUE, ENUM(), column types and definitions.. See:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/C/o/Column_types.html Gurhan Ozen MCI WorldCom Quality Assurance Team [EMAIL PROTECTED] ph: 703-449-4754 Vnet: 228-4754 AIM: Greywolf1923 -----Original Message----- From: Mohamed Farouk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 9:31 AM To: [EMAIL PROTECTED] Subject: Mandatory Fields Dear Sir I want to ask how can i assign a field as mandatory and other as optional using the Mysql Database. Regards -- Mohamed Farouk System Engineer IT Dept. MEMScAP 9 St, Ebn Batouta, Beside the Baron, Cairo, Egypt Tel: 4146860 Ext: 102 Mobile: 0101828653 http://www.memscap.com ------------------------------------------------------------------------- "This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person." ------------------------------------------------------------------------- --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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