mysql group by 报错

use mysql; 

select @@global.sql_mode  

set @@global.sql_mode
=`STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION `;

flush privileges;
flush hosts;