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;