1 row in set (0.00 sec) MariaDB [test]> SHOW GLOBAL VARIABLES LIKE 'binlog_row_image'; +------------------+---------+ | Variable_name | Value | +------------------+---------+ | binlog_row_image | MINIMAL | +------------------+---------+ 1 row in set (0.00 sec) MariaDB [test]> SHOW CREATE TABLE t1_without_timestamp\G *************************** 1. row *************************** Table: t1_without_timestamp Create Table: CREATE TABLE `t1_without_timestamp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `data` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 1 row in set (0.00 sec) MariaDB [test]> SHOW CREATE TABLE t2_with_timestamp\G *************************** 1. row *************************** Table: t2_with_timestamp Create Table: CREATE TABLE `t2_with_timestamp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `data` varchar(100) DEFAULT NULL, `culprit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 1 row in set (0.00 sec) #170718 13:04:50 server id 55055 end_log_pos 5550 GTID 0-55055-57 trans /*!100001 SET @@session.gtid_seq_no=57*//*!*/; BEGIN /*!*/; # at 5550 #170718 13:04:50 server id 55055 end_log_pos 5612 Table_map: `test`.`t1_without_timestamp` mapped to number 85 # at 5612 #170718 13:04:50 server id 55055 end_log_pos 5661 Update_rows: table id 85 flags: STMT_END_F ### UPDATE `test`.`t1_without_timestamp` ### WHERE ### @1=1 ### SET ### @2='t1_some_data' # at 5661 #170718 13:04:50 server id 55055 end_log_pos 5688 Xid = 317 COMMIT/*!*/; # at 5688 #170718 13:04:58 server id 55055 end_log_pos 5726 GTID 0-55055-58 trans /*!100001 SET @@session.gtid_seq_no=58*//*!*/; BEGIN /*!*/; # at 5726 #170718 13:04:58 server id 55055 end_log_pos 5787 Table_map: `test`.`t2_with_timestamp` mapped to number 90 # at 5787 #170718 13:04:58 server id 55055 end_log_pos 5851 Update_rows: table id 90 flags: STMT_END_F ### UPDATE `test`.`t2_with_timestamp` ### WHERE ### @1=1 ### @2='stuff' ### @3=1500375210 ### SET ### @2='t2_some_data' ### @3=1500375898 # at 5851 #170718 13:04:58 server id 55055 end_log_pos 5878 Xid = 318 COMMIT/*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;