📄 rpl_heap.result
字号:
reset master;drop table if exists t1;create table t1 type=HEAP select 10 as a;insert into t1 values(11);show binlog events from 79;Log_name Pos Event_type Server_id Orig_log_pos Infomaster-bin.001 79 Query 1 79 use `test`; create table t1 type=HEAP select 10 as amaster-bin.001 154 Query 1 154 use `test`; insert into t1 values(11)reset slave;start slave;show create table t1;Table Create Tablet1 CREATE TABLE `t1` ( `a` bigint(2) NOT NULL default '0') TYPE=HEAPselect * from t1;a1011select * from t1;aselect * from t1 limit 10;ashow binlog events in 'master-bin.002' from 79;Log_name Pos Event_type Server_id Orig_log_pos Infomaster-bin.002 79 Query 1 79 use `test`; DELETE FROM `test`.`t1`select * from t1;adrop table t1;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -