SQL
CREATE TABLE `qc_work` (
`id` int NOT NULL AUTO_INCREMENT,
`time_start` timestamp NOT NULL,
`time_end` timestamp NOT NULL,
PRIMARY KEY (`id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
报错
Invalid default value for 'time_end'
解决方法
vi /usr/local/etc/my.cnf
添加内容:
sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
重启
mysql.server restart