Server System Variables Dynamic Yes SET_VAR  Hint Applies Yes Type Boolean Default Value OFF If enabled,  sql_buffer_result  forces results from  SELECT  statements to be put into temporary tables. This helps MySQL free the table locks early and can be beneficial in cases where it takes a long time to send results to the client. The default value is  OFF . System Variable sql_log_off Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF Valid Values OFF  (enable logging) ON  (disable logging) This variable controls whether logging to the general query log is disabled for the current session (assuming that the general query log itself is enabled). The default value is  OFF  (that is, enable logging). To disable or enable general query logging for the current session, set the session  sql_log_off variable to  ON  or  OFF . Setting the session value of this system variable is a restricted operation. The session user must have privileges sufficient to set restricted session variables. See Section 5.1.9.1, “System Variable Privileges” . Command-Line Format --sql-mode=name System Variable sql_mode Scope Global, Session Dynamic Yes SET_VAR  Hint Applies Yes Type Set Default Value ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ZERO_IN_DATE NO_ZERO_DATE ERROR_FOR_DIVISION_BY_ZERO NO_ENGINE_SUBSTITUTION Valid Values ALLOW_INVALID_DATES ANSI_QUOTES ERROR_FOR_DIVISION_BY_ZERO HIGH_NOT_PRECEDENCE 886 • sql_log_off • sql_mode