原文链接:
    https://www.pianshen.com/article/62121107499/

    修改sql_mode以解决此问题
    系统:centOS7.5

    修改方法:

    1. 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’

    image.png
    3.重启服务

    1. systemctl restart mysqld.service