关于MySql的错误记录

1：报错

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rent.ct_order_audit_record.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

错误原因： Mysql5.7版本以上对group by 分组有了新需求，要求group by 后的字段要与select后查询的字段一致，否则就会报错

解决方法 1：使用distinct函数取代group by

永久修改配置文件‌
在MySQL配置文件（如my.cnf或my.ini）的[mysqld]部分添加：

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

进入my.cnf增加下面这句话，然后重启MySql

sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';