INTVAR_EVENT
A INTVAR_EVENT is written every time a statement uses an auto increment column or 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 .-?..
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
