MySQL的sql_mode问题：Incorrect datetime value，doesn’t have a default value

2021-02-22 05:21:35 字数 173 阅读 599

查看当前sql_mode

show variables like 'sql_mode';

set global sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';