mysql gruop by语句出错问题

 select @@sql_mode;  

去掉ONLY_FULL_GROUP_BY

解决

etc/my.cof

[mysqld]下

sql-mode=NO_UNSIGNED_SUBTRACTION,NO_ENGINE_SUBSTITUTION