SET @start_global_value = @@global.sql_log_update;
SELECT @start_global_value;
@start_global_value
1
select @@global.sql_log_update;
@@global.sql_log_update
1
select @@session.sql_log_update;
@@session.sql_log_update
1
show global variables like 'sql_log_update';
Variable_name	Value
sql_log_update	ON
show session variables like 'sql_log_update';
Variable_name	Value
sql_log_update	ON
select * from information_schema.global_variables where variable_name='sql_log_update';
VARIABLE_NAME	VARIABLE_VALUE
SQL_LOG_UPDATE	ON
select * from information_schema.session_variables where variable_name='sql_log_update';
VARIABLE_NAME	VARIABLE_VALUE
SQL_LOG_UPDATE	ON
set global sql_log_update=1;
Warnings:
Note	1315	The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MySQL 5.6.
set session sql_log_update=ON;
Warnings:
Note	1315	The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MySQL 5.6.
select @@global.sql_log_update;
@@global.sql_log_update
1
select @@session.sql_log_update;
@@session.sql_log_update
1
show global variables like 'sql_log_update';
Variable_name	Value
sql_log_update	ON
show session variables like 'sql_log_update';
Variable_name	Value
sql_log_update	ON
select * from information_schema.global_variables where variable_name='sql_log_update';
VARIABLE_NAME	VARIABLE_VALUE
SQL_LOG_UPDATE	ON
select * from information_schema.session_variables where variable_name='sql_log_update';
VARIABLE_NAME	VARIABLE_VALUE
SQL_LOG_UPDATE	ON
set global sql_log_update=0;
Warnings:
Note	1315	The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MySQL 5.6.
set session sql_log_update=OFF;
Warnings:
Note	1315	The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MySQL 5.6.
select @@global.sql_log_update;
@@global.sql_log_update
0
select @@session.sql_log_update;
@@session.sql_log_update
0
show global variables like 'sql_log_update';
Variable_name	Value
sql_log_update	OFF
show session variables like 'sql_log_update';
Variable_name	Value
sql_log_update	OFF
select * from information_schema.global_variables where variable_name='sql_log_update';
VARIABLE_NAME	VARIABLE_VALUE
SQL_LOG_UPDATE	OFF
select * from information_schema.session_variables where variable_name='sql_log_update';
VARIABLE_NAME	VARIABLE_VALUE
SQL_LOG_UPDATE	OFF
set global sql_log_update=1.1;
ERROR 42000: Incorrect argument type to variable 'sql_log_update'
set global sql_log_update=1e1;
ERROR 42000: Incorrect argument type to variable 'sql_log_update'
set global sql_log_update="foo";
ERROR 42000: Variable 'sql_log_update' can't be set to the value of 'foo'
SET @@global.sql_log_update = @start_global_value;
Warnings:
Note	1315	The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MySQL 5.6.
SELECT @@global.sql_log_update;
@@global.sql_log_update
1