问题是由于sql_modes导致的,你通过命令检查当前的sql_modes:
show variables like 'sql_mode';
删除sql_mode中的“NO_ZERO_IN_DATE,NO_ZERO_DATE
”就可以了。
通过root权限用下命令将sql_mode全局设置为:
set global sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
Related Posts
- #1698 – Access denied for user ‘root’@’localhost’
- Warning in ./libraries/plugin_interface.lib.php#551
- Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable
- npm ERR! gyp verb `which` failed Error: not found: python
- c++ ‘-DNODE_GYP_MODULE_NAME=libsass’ ‘-DUSING_UV_SHARED=1’ ‘-
- Sublime Text 自动换行
- Failed to change timestamp of the file in IntelliJ IDEA
- macOS中staff和wheel是什么?
- run again with the –allow-net flag – Deno