Mysql 5.7 SQL MODE

1 min read

show the last queries

mysql>SET GLOBAL log_output = 'FILE';
mysql>SET GLOBAL general_log = 'ON';
mysql>SHOW VARIABLES WHERE Variable_name LIKE 'general_log_file'

Disable ONLY_FULL_GROUP_BY

SHOW VARIABLES WHERE Variable_name LIKE 'sql_mode';
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                                                                     |
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| sql_mode      | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

[mysqld]  
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> SHOW CREATE TABLE <tablename>;
SHELL MYSQL

Related