1.查看sql_mode

mysql> select @@sql_mode;

+--------------------------------------------------------------------------------------------------------------+

| @@sql_mode                                                                                                  |

+--------------------------------------------------------------------------------------------------------------+

| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

+--------------------------------------------------------------------------------------------------------------+

2.配置文件修改sql_mode

/etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES