/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

0 vote359 views1 answer
Less than and between in sql query
SQL
0 vote351 views1 answer
Mysql query single row
SQL
0 vote342 views1 answer
Check for directory in bash
SQL
3 votes355 views3 answers
Into in sql
SQL
-1 vote342 views1 answer
Export mysql table to file
SQL
3 votes359 views1 answer
Oracle revoke grant
SQL
0 vote406 views1 answer
Mysql relationships between tables
SQL
18 votes365 views6 answers
Laravel form validation
SQL
0 vote351 views1 answer
Mariadb mysql root access denied
SQL
2 votes382 views2 answers
Storing timezones in postgres
SQL