GROUP BY clause; this is incompati

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

2 votes229 views1 answer
How to select from mssql
SQL
0 vote167 views1 answer
Sqlite löschen einer tabelle
SQL
2 votes175 views1 answer
Mysql select true or false
SQL
0 vote163 views1 answer
Join in update query in mysql
SQL
2 votes158 views1 answer
No data found oracle
SQL
0 vote155 views1 answer
How to find date from date table in sql
SQL
-2 votes168 views3 answers
Sqlite reset autoincrement
SQL
0 vote158 views1 answer
Mysql grant grant option
SQL
-1 vote197 views1 answer
MYSQL stored procedure select from
SQL
0 vote167 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL