1
drop table if exists t1;
3
set character_set_database = cp932;
5
CREATE TABLE t1(f1 blob);
6
PREPARE stmt1 FROM 'INSERT INTO t1 VALUES(?)';
8
EXECUTE stmt1 USING @var1;
9
show binlog events from <binlog_start>;
10
Log_name Pos Event_type Server_id End_log_pos Info
11
master-bin.000001 # Query # # use `test`; CREATE TABLE t1(f1 blob)
12
master-bin.000001 # Query # # use `test`; BEGIN
13
master-bin.000001 # Table_map # # table_id: # (test.t1)
14
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
15
master-bin.000001 # Query # # use `test`; COMMIT
16
SELECT HEX(f1) FROM t1;