46 lines
1.1 KiB
Plaintext
46 lines
1.1 KiB
Plaintext
show global variables like "binlog_format";
|
|
Variable_name Value
|
|
binlog_format ROW
|
|
show global variables like "slave_exec_mode";
|
|
Variable_name Value
|
|
slave_exec_mode SMART
|
|
show global variables like "binlog_format";
|
|
Variable_name Value
|
|
binlog_format ROW
|
|
show global variables like "binlog_row_image";
|
|
Variable_name Value
|
|
binlog_row_image MINIMAL
|
|
create table `t1`(
|
|
`pk` int(11) not null default '0',
|
|
`uk` int(11),
|
|
`a` int(11),
|
|
primary key(`pk`),
|
|
unique key(`uk`)
|
|
)engine=innodb default charset=gbk;
|
|
Warnings:
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
insert into t1 values(1,1,1);
|
|
select * from t1;
|
|
pk uk a
|
|
1 1 1
|
|
set force_revise=ON;
|
|
set sql_log_bin=OFF;
|
|
delete from t1 where pk=1;
|
|
select * from t1;
|
|
pk uk a
|
|
set force_revise=OFF;
|
|
set sql_log_bin=ON;
|
|
update t1 set uk=10 where pk=1;
|
|
select * from t1;
|
|
pk uk a
|
|
1 10 1
|
|
include/wait_for_slave_sql_error.inc [errno=1032]
|
|
select * from t1;
|
|
pk uk a
|
|
select * from t1;
|
|
pk uk a
|
|
1 10 1
|
|
drop table t1;
|