mysql 5.7 执行group by 语句报错

执行这段话报错:SELECT path_md5,path,count(1) FROM aliexpress_hacker_cate GROUP BY path_md5  

解决方法:

SET sql_mode = '';

 参考文章:http://www.520sz.com/mysql-5-7-10-group-by-error.html 

posted @ 2019-08-28 17:01  那时的吻狠陶醉  阅读(447)  评论(0编辑  收藏  举报