[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
Solution:
1.mysql -u root -p login mysql
2.show variables like ‘%sql_mode%’;
3.set global sql_mode=(select replace(@@sql_mode,’ONLY_FULL_GROUP_BY’,”));
4.exit;
1.mysql -u root -p login mysql
2.show variables like ‘%sql_mode%’;
3.set global sql_mode=(select replace(@@sql_mode,’ONLY_FULL_GROUP_BY’,”));
4.exit;
Restart Navicat and you will not get this error anymore.
Similar Posts:
- [Solved] MySQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
- [Solved] MYSQL Command gruop by Error: this is incompatible with sql_mode=only_full_group_by
- SELECT list is not in GROUP BY clause and contains nonaggregated column
- [Solved] SELECT list is not in GROUP BY clause and contains nonaggregated
- SELECT list is not in GROUP BY clause and contains nonaggregated
- Oracle error: not a group by expression [How to Solve]
- Error: not a group by expression [How to Solve]
- [Solved] MYSQL8 group by Error: Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY
- Mysql Error: 1140 – In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column ‘a.store’; this is incompatible with sql_mode=only_full_group_by
- [Solved] MYSQL Error 1040 (HY000): too many connections