INTVAR_EVENT

A INTVAR_EVENT is written every time a statement uses an auto increment column or LAST_INSERT_ID() function.

  • Event Type is 5 (0x05)

Fields

Type

0x00invalid value
0x01LAST_INSERT_ID
0x02Insert 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                                   .-?..

Comments

Comments loading...
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.