1.修改my.ini(windows)或者my.cnf(centos)
在[mysqld]下加入
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
2.重启mysql
systemctl restart mysql
1.修改my.ini(windows)或者my.cnf(centos)
在[mysqld]下加入
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
2.重启mysql
systemctl restart mysql