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

Reply via email to