原文链接:
https://www.pianshen.com/article/62121107499/
修改sql_mode以解决此问题
系统:centOS7.5
修改方法:
vim /etc/my.cnf
2.在[mysqld]下加入
sql_mode=’STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION’
3.重启服务
systemctl restart mysqld.service