/SQL/Select list is not in group by clause

Select list is not in group by clause

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Source: stackoverflow.com

Expression number 1 of select list is not in group by clause

mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

Source: stackoverflow.com

Similar codes

1 vote128 views1 answer
Oracle get current schema
SQL
0 vote141 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
19 votes130 views3 answers
Grant mysql
SQL
3 votes138 views1 answer
Postgres add not null to existing column
SQL
0 vote146 views1 answer
Start stop mysql linux
SQL
1 vote129 views1 answer
How to remove identity from a column in sql server
SQL
0 vote120 views1 answer
Sql server inner join convert collation
SQL
1 vote125 views1 answer
Oracle undo usage per session
SQL
2 votes121 views1 answer
Mysql find tables with name
SQL
10 votes143 views4 answers
Join multiple tables in sql
SQL