sql_log_update_basic.result 3.03 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
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:
25
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.
26 27
set session sql_log_update=ON;
Warnings:
28
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.
29 30 31
select @@global.sql_log_update;
@@global.sql_log_update
1
32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
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:
49
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.
50
set session sql_log_update=OFF;
51
Warnings:
52
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.
53 54 55
select @@global.sql_log_update;
@@global.sql_log_update
0
56 57
select @@session.sql_log_update;
@@session.sql_log_update
58 59 60 61 62 63 64 65 66 67 68 69 70
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
71 72 73 74 75 76 77 78
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:
79
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.
80 81 82
SELECT @@global.sql_log_update;
@@global.sql_log_update
1