1./etc/mysql/mysql.conf.d/mysqld.cnf
或者my.cnf 总之就是mysql的配置文件
2.查看当前的sql模式
select @
sql_mode
='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
4.重启
service mysql restart
或者my.cnf 总之就是mysql的配置文件
select @
sql_mode
='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
service mysql restart
转载于:https://www.cnblogs.com/jycjy/p/11361696.html