📄 rpl_multi_delete.test
字号:
source include/master-slave.inc;create table t1 (a int);create table t2 (a int);insert into t1 values (1);insert into t2 values (1);delete t1.* from t1, t2 where t1.a = t2.a;save_master_pos;select * from t1;select * from t2;connection slave;sync_with_master;select * from t1;select * from t2;# End of 4.1 tests# Check if deleting 0 rows is binlogged (BUG#13348)connection master;delete from t1;delete from t2;sync_slave_with_master;# force a difference to see if master's multi-DELETE will correct itinsert into t1 values(1);insert into t2 values(1);connection master;DELETE t1.*, t2.* from t1, t2;sync_slave_with_master;select * from t1;select * from t2;connection master;drop table t1,t2;sync_slave_with_master;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -