Jump to content

Question On Mysql Command


satimis

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...