📄 rpl_misc_functions.result
字号:
stop slave;drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;reset master;reset slave;drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;start slave;create table t1(id int, i int, r1 int, r2 int, p varchar(100));insert into t1 values(1, connection_id(), 0, 0, "");insert into t1 values(2, 0, rand()*1000, rand()*1000, "");set sql_log_bin=0;insert into t1 values(6, 0, rand(), rand(), "");delete from t1 where id=6;set sql_log_bin=1;insert into t1 values(3, 0, 0, 0, password('does_this_work?'));insert into t1 values(4, connection_id(), rand()*1000, rand()*1000, password('does_this_still_work?'));select * into outfile 'rpl_misc_functions.outfile' from t1;create table t2 like t1;load data local infile 'MYSQLTEST_VARDIR/master-data/test/rpl_misc_functions.outfile' into table t2;select * from t1, t2 where (t1.id=t2.id) and not(t1.i=t2.i and t1.r1=t2.r1 and t1.r2=t2.r2 and t1.p=t2.p);id i r1 r2 p id i r1 r2 pstop slave;drop table t1;drop table t1;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -