satimis Posted December 7, 2008 Share Posted December 7, 2008 Hi folks,mysql versionVer 14.12 Distrib 5.0.32I ran following command creating a table:- 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) 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. TIAB.R.satimis Link to comment Share on other sites More sharing options...
Synook Posted December 7, 2008 Share Posted December 7, 2008 A field is either NULL or NOT NULL... it can't be neither Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.