来源:
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ccx_esg.rating_basic_info.rating_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_b
这个就是报错,网上说了一大通,说更改my.cnf但是如果遇到有的电脑没有这个配置得时候,那么你就开始了天坑之路,
具体为什么是天坑之路呢?
SET @@sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
上面这句话直接解决,哦对了,不要直接复制我的通过下面
SELECT @@sql_mode;
查询你的匹配值然后删除
ONLY_FULL_GROUP_BY
然后
SET @@GLOBAl.sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'
上面这句是必须的,不然,你通过代码使用还是会出问题