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

0 vote207 views1 answer
Radius search with point data in mysql
SQL
0 vote147 views1 answer
Mysql show category once count how many products
SQL
0 vote158 views1 answer
Mysql trim characters
SQL
0 vote156 views1 answer
Add alternate add column sql
SQL
1 vote165 views1 answer
Mysql select from outside
SQL
0 vote165 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote222 views1 answer
Order by number of character in sql
SQL
26 votes155 views2 answers
What is the sql statement that finds duplicate usernames
SQL
2 votes256 views1 answer
Mysql create user with remote access
SQL
1 vote166 views1 answer
Mysql return if it contains
SQL