📄 binlog_row_binlog.result

📁 开启mysql的远程连接的方法 mysql-noinstall-5.1.6-alpha-win32.zip
💻 RESULT
字号:
drop table if exists t1, t2;reset master;create table t1 (a int) engine=bdb;create table t2 (a int) engine=innodb;begin;insert t1 values (5);commit;begin;insert t2 values (5);commit;show binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin.000001	#	Query	1	#	use `test`; create table t1 (a int) engine=bdbmaster-bin.000001	#	Query	1	#	use `test`; create table t2 (a int) engine=innodbmaster-bin.000001	#	Query	1	#	use `test`; BEGINmaster-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Query	1	#	use `test`; COMMITmaster-bin.000001	#	Query	1	#	use `test`; BEGINmaster-bin.000001	#	Table_map	1	#	test.t2master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Xid	1	#	COMMIT /* xid= */drop table t1,t2;reset master;create table t1 (n int) engine=innodb;begin;commit;drop table t1;show binlog events in 'master-bin.000001' from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin.000001	#	Query	1	#	use `test`; create table t1 (n int) engine=innodbmaster-bin.000001	#	Query	1	#	use `test`; BEGINmaster-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Table_map	1	#	test.t1master-bin.000001	#	Write_rows	1	#	master-bin.000001	#	Xid	1	#	COMMIT /* xid= */master-bin.000001	#	Rotate	1	#	master-bin.000002;pos=4show binlog events in 'master-bin.000002' from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin.000002	#	Query	1	#	use `test`; drop table t1
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -