/*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 5780 #773 18:9:27 server id 1 end_log_pos 5866 Query thread_id=8 exec_time=0 error_code=0 use test/*!*/; SET TIMESTAMP=1183511367/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/; SET @@session.sql_mode=0/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; drop table if exists t2/*!*/; # at 5866 #773 18:9:27 server id 1 end_log_pos 6032 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1183511367/*!*/; CREATE TABLE `t2` ( `login` varchar(24) default NULL, `date` timestamp NULL default NULL) ENGINE=MyISAM/*!*/; # at 6032 #773 18:9:27 server id 1 end_log_pos 6173 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1183511367/*!*/; SET @@session.time_zone='SYSTEM'/*!*/; insert into t2 (login, date) values ('test1', now()), ('test2', NOW())/*!*/; # at 6173 #773 18:9:27 server id 1 end_log_pos 6311 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1183511367/*!*/; SET @@session.time_zone='Etc/GMT-9'/*!*/; update t2 set date = '1970-01-01 09:59:59' where login = 'test1'/*!*/; # at 6311 #773 18:9:28 server id 1 end_log_pos 6438 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1183511368/*!*/; update t2 set date = '1970-01-01 09:59:59' where login = 'test2'/*!*/; # at 6438 #773 18:9:42 server id 1 end_log_pos 6565 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1183511382/*!*/; update t2 set date = '1970-01-01 09:59:59' where login = 'test1'/*!*/; # at 6565 #773 18:12:8 server id 1 end_log_pos 6651 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1183511528/*!*/; drop table if exists t2/*!*/; # at 6651 #773 18:12:8 server id 1 end_log_pos 6817 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1183511528/*!*/; CREATE TABLE `t2` ( `login` varchar(24) default NULL, `date` timestamp NULL default NULL) ENGINE=MyISAM/*!*/; # at 6817 #773 18:12:8 server id 1 end_log_pos 6962 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1183511528/*!*/; SET @@session.time_zone='Etc/GMT-10'/*!*/; insert into t2 (login, date) values ('test1', now()), ('test2', NOW())/*!*/; # at 6962 #773 18:12:8 server id 1 end_log_pos 7100 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1183511528/*!*/; SET @@session.time_zone='Etc/GMT-9'/*!*/; update t2 set date = '1970-01-01 09:59:59' where login = 'test1'/*!*/; # at 7100 #773 18:12:9 server id 1 end_log_pos 7227 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1183511529/*!*/; update t2 set date = '1970-01-01 09:59:59' where login = 'test2'/*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;