set @general_log.saved = @@general_log;

set @log_output.saved = @@log_output;

set @sql_log_off.saved = @@sql_log_off;

set global general_log = 1, log_output = 'TABLE';

set sql_log_off = 0;

truncate table mysql.general_log;

select 1;

set statement SQL_LOG_OFF = 1 for select 2;

set SQL_LOG_OFF = 1;

select 3;

select * from mysql.general_log;

set sql_log_off = @sql_log_off.saved;

set global general_log = @general_log.saved;

set global log_output = @log_output.saved;

+----------------------------+------------------------------+-----------+-----------+--------------+--------------------------------------------+

| event_time                 | user_host                    | thread_id | server_id | command_type | argument                                   |

+----------------------------+------------------------------+-----------+-----------+--------------+--------------------------------------------+

| 2014-11-01 21:23:07.658097 | root[root] @ localhost [::1] |         9 |         1 | Query        | select 1                                   |

| 2014-11-01 21:23:07.851033 | root[root] @ localhost [::1] |         9 |         1 | Query        | set statement SQL_LOG_OFF = 1 for select 2 |

| 2014-11-01 21:23:07.852758 | root[root] @ localhost [::1] |         9 |         1 | Query        | set SQL_LOG_OFF = 1                        |

+----------------------------+------------------------------+-----------+-----------+--------------+--------------------------------------------+