rpl_heap.result

来自「这是linux下运行的mysql软件包,可用于linux 下安装 php + m」· RESULT 代码 · 共 30 行

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	Info
master-bin.001	79	Query	1	79	use `test`; create table t1 type=HEAP select 10 as a
master-bin.001	154	Query	1	154	use `test`; insert into t1 values(11)
reset slave;
start slave;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` bigint(2) NOT NULL default '0'
) TYPE=HEAP
select * from t1;
a
10
11
select * from t1;
a
select * from t1 limit 10;
a
show binlog events in 'master-bin.002' from 79;
Log_name	Pos	Event_type	Server_id	Orig_log_pos	Info
master-bin.002	79	Query	1	79	use `test`; DELETE FROM `test`.`t1`
select * from t1;
a
drop table t1;