/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

3 votes294 views1 answer
If 0 return null else return query mysql
SQL
4 votes276 views1 answer
And or sql order of operations
SQL
0 vote345 views1 answer
Alter boolean column postgresql
SQL
1 vote329 views1 answer
Sql how to duplicate a table
SQL
1 vote332 views1 answer
Drush sql-dump
SQL
35 votes336 views6 answers
Postgres
SQL
5 votes316 views1 answer
Oracle sysdate
SQL
0 vote307 views1 answer
Sql right characters
SQL
2 votes355 views3 answers
Mysql pass command from command line
SQL
0 vote307 views1 answer
Sql comparison operators
SQL