禁用ONLY_FULL_GROUP_BY

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));



来源:https://stackoverflow.com/questions/23921117/disable-only-full-group-by