sql查询自己数据库的sql mode:
select @@global.sql_mode
结果如下ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERONO_ENGINE_SUBSTITUTION
去掉ONLY_FULL_GROUP_BY,重新设置值:
set @@global.sql_mode
=‘STRICT_TRANS_TABLES,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERONO_ENGINE_SUBSTITUTION’