MySQL Handling of GROUP BY

问题：which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

报以上错误执行以下ｓｑｌ语句可解决
set global sql_mode='';

本博客所有文章如无特别注明均为原创。
复制或转载请以超链接形式注明转自锅巴菜，原文地址《MySQL Handling of GROUP BY》