在MySQL中执行查询时只与_FULL_GROUY相关的错误
SELECT List的表达式#1不在GROUP BY子句中,而是包含非聚合列‘Support_Desk.mod_user_groups.group_id’,该列在功能上不依赖于GROUP BY子句中的列;这与SQL_MODE=Only_FULL_GROU
SELECT mod_users_groups.group_id AS 'value', group_name AS 'text' FROM mod_users_groupsLEFT JOIN mod_users_data ON mod_users_groups.group_id = mod_users_data.group_id WHERE mod_users_groups.active = 1 AND mod_users_groups.department_id = 1 AND mod_users_groups.manage_work_orders = 1 AND group_name != 'root' AND group_name != 'superuser' GROUP BY group_name HAVING COUNT(`user_id`) > 0 ORDER BY group_name
only_full_group_by
only_full_group_by
蓝山帝景
相关分类