/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 vote205 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote167 views0 answer
SQL
0 vote199 views1 answer
Run mssql server terminal
SQL
0 vote220 views1 answer
Learnxinyminutes sql
SQL
0 vote191 views1 answer
Wordpress sql find and replace
SQL
0 vote161 views1 answer
Sql table to store status
SQL
0 vote188 views1 answer
Import sql mysql ubuntu
SQL
0 vote209 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote210 views1 answer
How to check which table has data in mysql
SQL
0 vote245 views1 answer
Jpa generationtype sequence mysql
SQL