Hi folks,
mysql version
Ver 14.12 Distrib 5.0.32
I ran following command creating a table:-
Code:
mysql> CREATE TABLE `tblPerdition` (
-> `user` varchar(128),
-> `servername` varchar(255) default '',
-> `port` varchar(8) NULL default 'NULL',
-> PRIMARY KEY (`user`)
-> );
Query OK, 0 rows affected (0.00 sec)
Code:
mysql> DESCRIBE tblPerdition;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| user | varchar(128) | NO | PRI | | |
| servername | varchar(255) | YES | | | |
| port | varchar(8) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
I can't figure out how to made Null columns of 'user' blank (without NO)
and 'servername' blank (without YES)
Please help. TIA
B.R.
satimis
dBforums
>
About MySQL command
12-07-08, 05:49
Linear Mode
