MySQL5.7版本sql_mode=only_full_group_by问题详细解决办法_only_full_group_by,strict_trans_tables,no_zero_in_-CSDN博客

网站介绍:文章浏览阅读455次。查看sql_modeSELECT @@sql_mode;查询出来的值为:ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION去掉ONLY_FULL_GROUP_BY,重新设置值。SET @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZE_only_full_group_by,strict_trans_tables,no_zero_in_date,no_zero_date,error_fo