1.使用Navicat 链接5.7版本出现
mysql 5.7.9 [Err] 1055报错解决,[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY
使用:
SET sql_mode=(SELECT REPLACE(@@sql_mode,‘ONLY_FULL_GROUP_BY‘,‘‘));
2、
000-mysql小技巧
原文:http://www.cnblogs.com/bjlhx/p/7623769.html