Gecko [ 122.154.134.11 ]

Name	Size	Permission
binlog_base64_flag.result	3.74 KB	-rw-r--r--
binlog_bug23533.result	486 B	-rw-r--r--
binlog_bug36391.result	129 B	-rw-r--r--
binlog_database.result	5.28 KB	-rw-r--r--
binlog_delete_and_flush_index....	1.75 KB	-rw-r--r--
binlog_drop_if_exists.result	5.26 KB	-rw-r--r--
binlog_grant.result	1.18 KB	-rw-r--r--
binlog_incident.result	181 B	-rw-r--r--
binlog_index.result	5.2 KB	-rw-r--r--
binlog_innodb.result	6.05 KB	-rw-r--r--
binlog_innodb_row.result	2.47 KB	-rw-r--r--
binlog_killed.result	3.43 KB	-rw-r--r--
binlog_killed_simulate.result	1.25 KB	-rw-r--r--
binlog_mix_innodb_stat.result	610 B	-rw-r--r--
binlog_mixed_failure_mixing_en...	16.79 KB	-rw-r--r--
binlog_mixed_load_data.result	429 B	-rw-r--r--
binlog_multi_engine.result	4.59 KB	-rw-r--r--
binlog_mysqlbinlog-cp932.resul...	344 B	-rw-r--r--
binlog_mysqlbinlog2.result	36.63 KB	-rw-r--r--
binlog_mysqlbinlog_base64.resu...	1.69 KB	-rw-r--r--
binlog_mysqlbinlog_row.result	150.85 KB	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	239.94 KB	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	241.25 KB	-rw-r--r--
binlog_mysqlbinlog_row_trans.r...	16.1 KB	-rw-r--r--
binlog_old_versions.result	1.3 KB	-rw-r--r--
binlog_query_filter_rules.resu...	173 B	-rw-r--r--
binlog_reset_master.result	14 B	-rw-r--r--
binlog_row_binlog.result	76.4 KB	-rw-r--r--
binlog_row_ctype_cp932.result	87.42 KB	-rw-r--r--
binlog_row_ctype_ucs.result	1.27 KB	-rw-r--r--
binlog_row_drop_tmp_tbl.result	1.17 KB	-rw-r--r--
binlog_row_failure_mixing_engi...	18.09 KB	-rw-r--r--
binlog_row_innodb_stat.result	610 B	-rw-r--r--
binlog_row_insert_select.resul...	829 B	-rw-r--r--
binlog_row_mix_innodb_myisam.r...	32.72 KB	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	1.5 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	2.68 KB	-rw-r--r--
binlog_server_id.result	1.2 KB	-rw-r--r--
binlog_sf.result	1.67 KB	-rw-r--r--
binlog_sql_mode.result	3.51 KB	-rw-r--r--
binlog_start_comment.result	357 B	-rw-r--r--
binlog_statement_insert_delaye...	949 B	-rw-r--r--
binlog_stm_binlog.result	51.51 KB	-rw-r--r--
binlog_stm_blackhole.result	7.29 KB	-rw-r--r--
binlog_stm_ctype_cp932.result	87.42 KB	-rw-r--r--
binlog_stm_ctype_ucs.result	1.29 KB	-rw-r--r--
binlog_stm_do_db.result	2.08 KB	-rw-r--r--
binlog_stm_drop_tmp_tbl.result	2.3 KB	-rw-r--r--
binlog_stm_innodb_stat.result	610 B	-rw-r--r--
binlog_stm_insert_select.resul...	707 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.r...	30.23 KB	-rw-r--r--
binlog_stm_ps.result	811 B	-rw-r--r--
binlog_stm_row.result	2.48 KB	-rw-r--r--
binlog_stm_unsafe_warning.resu...	1.71 KB	-rw-r--r--
binlog_tmp_table.result	877 B	-rw-r--r--
binlog_truncate_innodb.result	2.45 KB	-rw-r--r--
binlog_truncate_myisam.result	439 B	-rw-r--r--
binlog_unsafe.result	13.81 KB	-rw-r--r--
binlog_write_error.result	3.58 KB	-rw-r--r--

Code Editor : binlog_mysqlbinlog_row_trans.result

#
# Preparatory cleanup.
#
DROP TABLE IF EXISTS t1, t2;
#
# We need a fixed timestamp to avoid varying results.
#
SET timestamp=1000000000;
#
# Delete all existing binary logs.
#
RESET MASTER;
#
# Create test tables.
#
CREATE TABLE t1 (
c1 INT,
c2 VARCHAR(20)
) ENGINE=InnoDB DEFAULT CHARSET latin1;
CREATE TABLE t2 (
c1 INT,
c2 VARCHAR(20)
) ENGINE=MyISAM DEFAULT CHARSET latin1;
#
# Start transaction #1, transactional table only, commit.
#
START TRANSACTION;
#
# Do some statements.
#
INSERT INTO t1 VALUES (1,'varchar-1'), (2,'varchar-2'), (3,'varchar-3');
UPDATE t1 SET c1 = c1 + 10;
DELETE FROM t1 WHERE c1 = 12;
#
# Commit transaction.
#
COMMIT;
SELECT * FROM t1;
c1	c2
11	varchar-1
13	varchar-3
TRUNCATE TABLE t1;
#
# Start transaction #2, transactional table only, rollback.
#
START TRANSACTION;
#
# Do some statements.
#
INSERT INTO t1 VALUES (1,'varchar-1'), (2,'varchar-2'), (3,'varchar-3');
UPDATE t1 SET c1 = c1 + 10;
DELETE FROM t1 WHERE c1 = 12;
#
# Rollback transaction.
#
ROLLBACK;
SELECT * FROM t1;
c1	c2
TRUNCATE TABLE t1;
#
# Start transaction #3, both tables, commit.
#
START TRANSACTION;
#
# Do some statements on the transactional table.
#
INSERT INTO t1 VALUES (1,'varchar-1'), (2,'varchar-2'), (3,'varchar-3');
UPDATE t1 SET c1 = c1 + 10;
DELETE FROM t1 WHERE c1 = 12;
#
# Do some statements on the non-transactional table.
#
INSERT INTO t2 VALUES (1,'varchar-1'), (2,'varchar-2'), (3,'varchar-3');
UPDATE t2 SET c1 = c1 + 10;
DELETE FROM t2 WHERE c1 = 12;
#
# Commit transaction.
#
COMMIT;
SELECT * FROM t1;
c1	c2
11	varchar-1
13	varchar-3
SELECT * FROM t2;
c1	c2
11	varchar-1
13	varchar-3
TRUNCATE TABLE t1;
TRUNCATE TABLE t2;
#
# Start transaction #4, both tables, rollback.
#
START TRANSACTION;
#
# Do some statements on the transactional table.
#
INSERT INTO t1 VALUES (1,'varchar-1'), (2,'varchar-2'), (3,'varchar-3');
UPDATE t1 SET c1 = c1 + 10;
DELETE FROM t1 WHERE c1 = 12;
#
# Do some statements on the non-transactional table.
#
INSERT INTO t2 VALUES (1,'varchar-1'), (2,'varchar-2'), (3,'varchar-3');
UPDATE t2 SET c1 = c1 + 10;
DELETE FROM t2 WHERE c1 = 12;
#
# Rollback transaction.
#
ROLLBACK;
Warnings:
Warning	1196	Some non-transactional changed tables couldn't be rolled back
SELECT * FROM t1;
c1	c2
SELECT * FROM t2;
c1	c2
11	varchar-1
13	varchar-3
TRUNCATE TABLE t1;
TRUNCATE TABLE t2;
#
# Flush all log buffers to the log file.
#
FLUSH LOGS;
#
# Call mysqlbinlog to display the log file contents.
#
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Start: binlog v 4, server v #.##.## created 010909  4:46:40 at startup
ROLLBACK/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
use `test`/*!*/;
SET TIMESTAMP=1000000000/*!*/;
SET @@session.pseudo_thread_id=#/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
CREATE TABLE t1 (
c1 INT,
c2 VARCHAR(20)
) ENGINE=InnoDB DEFAULT CHARSET latin1
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE TABLE t2 (
c1 INT,
c2 VARCHAR(20)
) ENGINE=MyISAM DEFAULT CHARSET latin1
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t1` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test`.`t1`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t1` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Update_rows: table id # flags: STMT_END_F
### UPDATE `test`.`t1`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=11 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=12 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=13 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t1` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test`.`t1`
### WHERE
###   @1=12 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Xid = #
COMMIT/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
BEGIN
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
TRUNCATE TABLE t1
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Xid = #
COMMIT/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
BEGIN
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
TRUNCATE TABLE t1
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Xid = #
COMMIT/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t1` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test`.`t1`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t1` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Update_rows: table id # flags: STMT_END_F
### UPDATE `test`.`t1`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=11 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=12 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=13 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t1` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test`.`t1`
### WHERE
###   @1=12 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t2` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test`.`t2`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t2` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Update_rows: table id # flags: STMT_END_F
### UPDATE `test`.`t2`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=11 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=12 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=13 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t2` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test`.`t2`
### WHERE
###   @1=12 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Xid = #
COMMIT/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
BEGIN
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
TRUNCATE TABLE t1
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Xid = #
COMMIT/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
TRUNCATE TABLE t2
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t1` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test`.`t1`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t1` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Update_rows: table id # flags: STMT_END_F
### UPDATE `test`.`t1`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=11 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=12 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### UPDATE `test`.`t1`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=13 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t1` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test`.`t1`
### WHERE
###   @1=12 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t2` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test`.`t2`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t2` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Update_rows: table id # flags: STMT_END_F
### UPDATE `test`.`t2`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=11 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=12 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
### SET
###   @1=13 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Table_map: `test`.`t2` mapped to number #
#010909  4:46:40 server id 1  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test`.`t2`
### WHERE
###   @1=12 /* INT meta=0 nullable=1 is_null=0 */
###   @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
ROLLBACK
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
BEGIN
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
TRUNCATE TABLE t1
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Xid = #
COMMIT/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
TRUNCATE TABLE t2
/*!*/;
# at #
#010909  4:46:40 server id 1  end_log_pos # 	Rotate to master-bin.000002  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
#
# Cleanup.
#
DROP TABLE t1, t2;

${this.title}

Code Editor : binlog_mysqlbinlog_row_trans.result