📄 mysqlbinlog.result

📁 这是linux下运行的mysql软件包,可用于linux 下安装 php + mysql + apach 的网络配置
💻 RESULT
字号:
set timestamp=1000000000;drop table if exists t1,t2;create table t1 (word varchar(20));create table t2 (id int auto_increment not null primary key);insert into t1 values ("abirvalg");insert into t2 values ();load data infile '../std_data_ln/words.dat' into table t1;load data infile '../std_data_ln/words.dat' into table t1;load data infile '../std_data_ln/words.dat' into table t1;load data infile '../std_data_ln/words.dat' into table t1;load data infile '../std_data_ln/words.dat' into table t1;insert into t1 values ("Alas");flush logs;--- Local --/*!40019 SET @@session.max_insert_delayed_threads=0*/;/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;ROLLBACK;use test;SET TIMESTAMP=1000000000;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 t1,t2;SET TIMESTAMP=1000000000;create table t1 (word varchar(20));SET TIMESTAMP=1000000000;create table t2 (id int auto_increment not null primary key);SET TIMESTAMP=1000000000;insert into t1 values ("abirvalg");SET INSERT_ID=1;SET TIMESTAMP=1000000000;insert into t2 values ();SET TIMESTAMP=1000000000;load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-1-0' INTO table t1;SET TIMESTAMP=1000000000;load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-2-0' INTO table t1;SET TIMESTAMP=1000000000;load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-3-0' INTO table t1;SET TIMESTAMP=1000000000;load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-4-0' INTO table t1;# End of log fileROLLBACK /* added by mysqlbinlog */;/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;--- Broken LOAD DATA --/*!40019 SET @@session.max_insert_delayed_threads=0*/;/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;use test;SET TIMESTAMP=1000000000;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;insert into t1 values ("Alas");# End of log fileROLLBACK /* added by mysqlbinlog */;/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;--- --database --/*!40019 SET @@session.max_insert_delayed_threads=0*/;/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;ROLLBACK;SET INSERT_ID=1;# End of log fileROLLBACK /* added by mysqlbinlog */;/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;--- --position --/*!40019 SET @@session.max_insert_delayed_threads=0*/;/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;use test;SET TIMESTAMP=1000000000;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;insert into t1 values ("Alas");# End of log fileROLLBACK /* added by mysqlbinlog */;/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;--- Remote --/*!40019 SET @@session.max_insert_delayed_threads=0*/;/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;ROLLBACK;use test;SET TIMESTAMP=1000000000;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 t1,t2;SET TIMESTAMP=1000000000;create table t1 (word varchar(20));SET TIMESTAMP=1000000000;create table t2 (id int auto_increment not null primary key);SET TIMESTAMP=1000000000;insert into t1 values ("abirvalg");SET INSERT_ID=1;SET TIMESTAMP=1000000000;insert into t2 values ();SET TIMESTAMP=1000000000;load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-1-2' INTO table t1;SET TIMESTAMP=1000000000;load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-2-2' INTO table t1;SET TIMESTAMP=1000000000;load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-3-2' INTO table t1;SET TIMESTAMP=1000000000;load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-4-2' INTO table t1;# End of log fileROLLBACK /* added by mysqlbinlog */;/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;--- Broken LOAD DATA --/*!40019 SET @@session.max_insert_delayed_threads=0*/;/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;use test;SET TIMESTAMP=1000000000;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;insert into t1 values ("Alas");# End of log fileROLLBACK /* added by mysqlbinlog */;/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;--- --database --/*!40019 SET @@session.max_insert_delayed_threads=0*/;/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;ROLLBACK;SET INSERT_ID=1;# End of log fileROLLBACK /* added by mysqlbinlog */;/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;--- --position --/*!40019 SET @@session.max_insert_delayed_threads=0*/;/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;use test;SET TIMESTAMP=1000000000;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;insert into t1 values ("Alas");# End of log fileROLLBACK /* added by mysqlbinlog */;/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;--- reading stdin --/*!40019 SET @@session.max_insert_delayed_threads=0*/;/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;ROLLBACK;use test;SET TIMESTAMP=1108844556;BEGIN;SET TIMESTAMP=1108844555;insert t1 values (1);# End of log fileROLLBACK /* added by mysqlbinlog */;/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;/*!40019 SET @@session.max_insert_delayed_threads=0*/;/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;use test;SET TIMESTAMP=1108844556;BEGIN;SET TIMESTAMP=1108844555;insert t1 values (1);# End of log fileROLLBACK /* added by mysqlbinlog */;/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;flush logs;create table t3 (f text character set utf8);create table t4 (f text character set cp932);flush logs;rename table t3 to t03, t4 to t04;select HEX(f) from t03;HEX(f)E382BDselect HEX(f) from t3;HEX(f)E382BDselect HEX(f) from t04;HEX(f)835Cselect HEX(f) from t4;HEX(f)835Cdrop table t1, t2, t03, t04, t3, t4;
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -