/*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 6702 #773 18:12:8 server id 1 end_log_pos 6651 Query thread_id=8 exec_time=0 error_code=0 use test/*!*/; SET TIMESTAMP=1183511528/*!*/; 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 6788 #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 6954 #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 7099 #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 7237 #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*/;