在MySql中建下表,总是报错,
DROP TABLE IF EXISTS `t_standardsample_step`;CREATE TABLE `t_standardsample_step` (
`SID` int(10) unsigned NOT NULL auto_increment,
`uid` varchar(20) default '系统自动采样',
`sample_step` decimal(5,0) default NULL,
`sample_Type` varchar(1) default '1',
`sample_bz` varchar(200) default NULL COMMENT '标准采样',
`sample_rq` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`sample_zt` varchar(1) default 'T',
PRIMARY KEY (`SID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
错误内容:
(0 row(s) affected)
(0 ms taken)Error Code : 1067
Invalid default value for 'uid'
(0 ms taken)
该怎么解决?
DROP TABLE IF EXISTS `t_standardsample_step`;CREATE TABLE `t_standardsample_step` (
`SID` int(10) unsigned NOT NULL auto_increment,
`uid` varchar(20) default '系统自动采样',
`sample_step` decimal(5,0) default NULL,
`sample_Type` varchar(1) default '1',
`sample_bz` varchar(200) default NULL COMMENT '标准采样',
`sample_rq` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`sample_zt` varchar(1) default 'T',
PRIMARY KEY (`SID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
错误内容:
(0 row(s) affected)
(0 ms taken)Error Code : 1067
Invalid default value for 'uid'
(0 ms taken)
该怎么解决?
[/align]