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
Mohamed,
Tuesday, April 30, 2002, 4:31:25 PM, you wrote:
MF I want to ask how can i assign a field as mandatory and other as
MF optional using the Mysql Database.
Take a look at the MySQL manual:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
There is a description of CREATE TABLE syntax
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:
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