May 24, 2018
Mysql: 禁用ONLY_FULL_GROUP_BY, 如何关闭ONLY_FULL_GROUP_BY, Error related to only_full_group_by when executing a query in MySql
错误描述:
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'support_desk.mod_users_groups.group_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决方法,即使取消(disable) only_full_group_by
方法1: 在mysql命令行:
mysql> set g… Read More