解决方法
show variables like "sql_mode";set sql_mode='';set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';
my.ini解决
(mysql-8.0.13)
sql-mode=
""
sql-mode=
"STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"
参考 https://www.cnblogs.com/yaogengzhu/p/9570302.html