/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 vote169 views1 answer
How to Activate the database
SQL
5 votes195 views4 answers
Sql check
SQL
0 vote140 views1 answer
Show size of all tables postgres
SQL
0 vote218 views1 answer
Oracle sql all days except weekends
SQL
3 votes149 views3 answers
Stop mysql service ubuntu
SQL
4 votes142 views1 answer
Mysql set max connections
SQL
0 vote137 views1 answer
Oracle search columns in schema
SQL
6 votes150 views2 answers
Foreign key sqlite3 python
SQL
0 vote140 views1 answer
Mysql search multiple tables
SQL
0 vote139 views1 answer
Is not null postgresql
SQL