📄 rpl_ps.test
字号:
## Test of replicating user variables#source include/master-slave.inc;#save_master_pos;#connection slave;#sync_with_master;#reset master;#connection master;--disable_warningsdrop table if exists t1;--enable_warningscreate table t1(n char(30));prepare stmt1 from 'insert into t1 values (?)';set @var1= "from-master-1";execute stmt1 using @var1;set @var1= "from-master-2-'',";execute stmt1 using @var1;select * from t1;set @var2= 'insert into t1 values (concat("from-var-", ?))';prepare stmt2 from @var2;set @var1='from-master-3';execute stmt2 using @var1;save_master_pos;connection slave;sync_with_master;select * from t1;connection master;drop table t1;save_master_pos;connection slave;sync_with_master;stop slave;# End of 4.1 tests
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -