mysql常用报错修改办法SELECT list is not in GROUP BY clause and contains nonaggregated column 'csi,with sql_mode=only_full_group_by

SELECT list is not in GROUP BY clause and contains nonaggregated column ‘csi xxxxxxxx.

ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause
and contains nonaggregated column ‘test.user.user_id’ which is not
functionally dependent on columns in GROUP BY clause; this is
incompatible with sql_mode=only_full_group_by

解决办法如下

到MySQL命令行或者中断运行如下sql代码即可：

    select @@global.sql_mode;
    set @@global.sql_mode=`STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION`
上述无法解决的话请运行下述
set sql_mode ='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';