/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 vote388 views1 answer
Mysql where sum > 0
SQL
1 vote332 views1 answer
Get url of cpanel database hostname
SQL
0 vote381 views1 answer
Table structure in sql
SQL
0 vote343 views1 answer
Mysql count with two joins
SQL
6 votes337 views2 answers
Return columns from table sql
SQL
1 vote394 views1 answer
Oracle plan hash value
SQL
0 vote354 views1 answer
Sql server select record with max id
SQL
10 votes455 views4 answers
Sql server pagination
SQL
3 votes347 views1 answer
Oracle show trigger code
SQL
0 vote358 views1 answer
Copy data from cell to cell mysql
SQL