Shulou(Shulou.com)06/01 Report--

Mysqlbinlog usage

Data generated using mysqlbinlog-vv

BINLOG'

BerdWRNIAAAAQQAAAE4rEwQAAIlGEAAAAAEADGhzY29tX3N1bGlhbwAKbHBfZXhwcmVzcwAFAw8P

CQEEwgHCAQA=

BerdWRdIAAAAPgAAAIwrEwQAAIlGEAAAAAMABf/gAwAAAAwA55Sz6YCa5b+r6YCSCABzaGVudG9u

ZwAAAAE=

'/ *! * /

# INSERT INTO hscom_suliao.lp_express

# SET

# @ 1room3 / * INT meta=0 nullable=0 is_null=0 * /

# @ 2 smoke? / * VARSTRING (450) meta=450 nullable=0 is_null=0 * /

# @ 3 VARSTRING meta=450 nullable=0 is_null=0 * /

# @ 4room0 / * MEDIUMINT meta=0 nullable=0 is_null=0 * /

# @ 5room1 / * TINYINT meta=0 nullable=0 is_null=0 * /

For example, @ 2 Chinese is garbled.

It is recommended to use mysqlbinlog-base64-output=DECODE-ROWS-v

# @ 2room1

# @ 3 thanks'

# @ 4pm'I've lost, but I've never been afraid'

# @ 5 minutes'

# @ 631

# @ 7 stories'

In this way, it can be converted directly into Chinese.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.