Mysql版本原因设置timestamp默认值为0000 00-00 00:00:00异常解决办法
【*】异常写法CREATE TABLE `qq_client` (`client_id` varchar(50) COLLATE utf8_bin NOT NULL,`client_name` varchar(50) COLLATE utf8_bin NOT NULL,`in_time` timestamp NOT NULL DEFAULT '0000 00-00 00:...
·
【*】异常写法
CREATE TABLE `qq_client` (
`client_id` varchar(50) COLLATE utf8_bin NOT NULL,
`client_name` varchar(50) COLLATE utf8_bin NOT NULL,
`in_time` timestamp NOT NULL DEFAULT '0000 00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
`expire` int(10) NOT NULL COMMENT '有效期,单位小时',
PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
【*】解决
CREATE TABLE `qq_client` (
`client_id` varchar(50) COLLATE utf8_bin NOT NULL,
`client_name` varchar(50) COLLATE utf8_bin NOT NULL,
`in_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`expire` int(10) NOT NULL COMMENT '有效期,单位小时',
PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
【*】解析
由于版本的问题,比较新Mysql不支持timestamp的默认值0000 00-00 00:00:00的写法,可以将其修改为CURRENT_TIMESTAMP
更多推荐
已为社区贡献1条内容
所有评论(0)