A USER_VAR_EVENT
is written every time a statement uses a user defined variable.
Event Type is 14
(0x0e
).
uint<4> The length of the user variable name.
string The name of the user variable.
uint<1> NULL
indicator.
0x00
STRING_RESULT
set @a:="foo"
0x01
REAL_RESULT
set @a:= @@timestamp
0x02
INT_RESULT
set @a:= 4
0x03
ROW_RESULT
(not in use)
0x04
DECIMAL_RESULT
set @a:=1.2345
0x01
unsigned
SET @foo:="bar"
From mysqlbinlog Utility, CRC32# at 511
#180610 10:26:43 server id 1 end_log_pos 554 CRC32 0x7dd93d6b User_var
SET @`foo`:=_utf8 X'626172' COLLATE `utf8_general_ci`/*!*/;
c3 e0 1c 5b 0e 01 00 00 00 2b 00 ...[.....+.
00 00 2a 02 00 00 00 00 03 00 00 00 66 6f 6f 00 ..*.........foo.
00 21 00 00 00 03 00 00 00 62 61 72 6b 3d d9 7d .!.......bark=.} ....
This page is licensed: CC BY-SA / Gnu FDL