mysql5.7的groupby 报错

执行mysql语句报错！ > ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xxx’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

查了下，是mysql5.7的问题！

sql_mode=only_full_group_by

解决办法！

进入mysql里！

mysql -uroot -p 
//输入密码

//然后 
set @@sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

再运行sql！ OK！

---

欢迎转载,但请附上原文地址哦,尊重原创,谢谢大家 本文地址: https://www.iphpt.com/detail/83/

---

本站(PHP --> Golang)已重构,代码开源

• Golang版本 代码地址: https://github.com/izghua/go-blog
• 原PHP版本 代码地址: https://github.com/xzghua/laravel-5-myblog

---