INTVAR_EVENT
An INTVAR_EVENT
is written every time a statement uses an auto increment column or the LAST_INSERT_ID()
function.
Header
Event Type is
5
(0x05
).
Fields
Type
0x00
Invalid value.
0x01
LAST_INSERT_ID.
0x02
Insert id (auto_increment).
Example From mysqlbinlog Utility, CRC32
# at 738
#180610 11:20:56 server id 1 end_log_pos 770 CRC32 0xf5a23f2d Intvar
SET LAST_INSERT_ID=1/*!*/;
Example Event As It's Written In The Binlog File
78 ed 1c 5b 05 01 00 00 00 20 00 x..[..... .
00 00 02 03 00 00 00 00 01 01 00 00 00 00 00 00 ................
00 2d 3f a2 f5 .-?..
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?