/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 vote188 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote295 views1 answer
Multiple replace value mssql
SQL
0 vote329 views4 answers
Stored procedure sql
SQL
0 vote180 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
3 votes210 views2 answers
Sqlite show table structure
SQL
7 votes196 views3 answers
Python and mysql connectivity
SQL
0 vote194 views1 answer
How to check even or odd in sql
SQL
2 votes197 views1 answer
Oracle sql drop column if exists
SQL
0 vote283 views1 answer
Dockerfile example for Django
SQL
0 vote234 views1 answer
Sql convert float to string
SQL