mysql 表字段添加默认值注释 mysql创建表设置默认值

CREATE TABLE `T_INPUTCONTENT` (               

                  `id` int(10) NOT NULL auto_increment,       

                  `title` varchar(40) default NULL,           

                  `content` longtext,                         

                  `subdate` timestamp(10) default now(),           

                  `status` varchar(10) NOT NULL default '0',  

                  PRIMARY KEY  (`id`)                         

                ) ENGINE=MyISAM DEFAULT CHARSET=latin1