168 lines
2.8 KiB
Plaintext
168 lines
2.8 KiB
Plaintext
Verbose statements from : write-partial-row.binlog
|
|
select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
|
|
stmt
|
|
### INSERT INTO `mysql`.`ndb_apply_status`
|
|
### SET
|
|
### @1=1
|
|
### @2=25769803786
|
|
### @3=''
|
|
### @4=0
|
|
### @5=0
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=3
|
|
### @2=3
|
|
### @3=3
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=1
|
|
### @2=1
|
|
### @3=1
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=2
|
|
### @2=2
|
|
### @3=2
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=4
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @3=40
|
|
### DELETE FROM `test`.`ba`
|
|
### WHERE
|
|
### @1=2
|
|
drop table raw_binlog_rows;
|
|
Verbose statements from : write-full-row.binlog
|
|
select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
|
|
stmt
|
|
### INSERT INTO `mysql`.`ndb_apply_status`
|
|
### SET
|
|
### @1=2
|
|
### @2=25769803786
|
|
### @3=''
|
|
### @4=0
|
|
### @5=0
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=3
|
|
### @2=3
|
|
### @3=3
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=1
|
|
### @2=1
|
|
### @3=1
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=2
|
|
### @2=2
|
|
### @3=2
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=4
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=40
|
|
### DELETE FROM `test`.`ba`
|
|
### WHERE
|
|
### @1=2
|
|
drop table raw_binlog_rows;
|
|
Verbose statements from : update-partial-row.binlog
|
|
select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
|
|
stmt
|
|
### INSERT INTO `mysql`.`ndb_apply_status`
|
|
### SET
|
|
### @1=3
|
|
### @2=25769803786
|
|
### @3=''
|
|
### @4=0
|
|
### @5=0
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=3
|
|
### @2=3
|
|
### @3=3
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=1
|
|
### @2=1
|
|
### @3=1
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=2
|
|
### @2=2
|
|
### @3=2
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=4
|
|
### UPDATE `test`.`ba`
|
|
### WHERE
|
|
### @1=4
|
|
### @3=4
|
|
### SET
|
|
### @1=4
|
|
### @3=40
|
|
### DELETE FROM `test`.`ba`
|
|
### WHERE
|
|
### @1=2
|
|
drop table raw_binlog_rows;
|
|
Verbose statements from : update-full-row.binlog
|
|
select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
|
|
stmt
|
|
### INSERT INTO `mysql`.`ndb_apply_status`
|
|
### SET
|
|
### @1=4
|
|
### @2=25769803786
|
|
### @3=''
|
|
### @4=0
|
|
### @5=0
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=3
|
|
### @2=3
|
|
### @3=3
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=1
|
|
### @2=1
|
|
### @3=1
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=2
|
|
### @2=2
|
|
### @3=2
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=4
|
|
### UPDATE `test`.`ba`
|
|
### WHERE
|
|
### @1=4
|
|
### @2=4
|
|
### @3=4
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=40
|
|
### DELETE FROM `test`.`ba`
|
|
### WHERE
|
|
### @1=2
|
|
drop table raw_binlog_rows;
|
|
SET @@SESSION.BINLOG_ROWS_QUERY_LOG_EVENTS = 1;
|
|
CREATE TABLE t1 (a VARCHAR(50));
|
|
INSERT INTO t1 VALUES ("
|
|
GRANT ALL ON *.* TO 'batman'/*!*/;
|
|
")|
|
|
DROP TABLE t1;
|