Code/Resource
Windows Develop
Linux-Unix program
Internet-Socket-Network
Web Server
Browser Client
Ftp Server
Ftp Client
Browser Plugins
Proxy Server
Email Server
Email Client
WEB Mail
Firewall-Security
Telnet Server
Telnet Client
ICQ-IM-Chat
Search Engine
Sniffer Package capture
Remote Control
xml-soap-webservice
P2P
WEB(ASP,PHP,...)
TCP/IP Stack
SNMP
Grid Computing
SilverLight
DNS
Cluster Service
Network Security
Communication-Mobile
Game Program
Editor
Multimedia program
Graph program
Compiler program
Compress-Decompress algrithms
Crypt_Decrypt algrithms
Mathimatics-Numerical algorithms
MultiLanguage
Disk/Storage
Java Develop
assembly language
Applications
Other systems
Database system
Embeded-SCM Develop
FlashMX/Flex
source in ebook
Delphi VCL
OS Develop
MiddleWare
MPI
MacOS develop
LabView
ELanguage
Software/Tools
E-Books
Artical/Document
mysqlbinlog.result
Package: mysql-4.1.16-win-src.zip [view]
Upload User: romrleung
Upload Date: 2022-05-23
Package Size: 18897k
Code Size: 4k
Category:
MySQL
Development Platform:
Visual C++
- 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/words.dat' into table t1;
- load data infile '../../std_data/words.dat' into table t1;
- load data infile '../../std_data/words.dat' into table t1;
- load data infile '../../std_data/words.dat' into table t1;
- load data infile '../../std_data/words.dat' into table t1;
- load data infile '../../std_data/words.dat' into table t1;
- insert into t1 values ("Alas");
- flush logs;
- --- Local --
- /*!40019 SET @@session.max_insert_delayed_threads=0*/;
- use test;
- SET TIMESTAMP=1000000000;
- 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 ();
- LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-1-0' INTO TABLE `t1` FIELDS TERMINATED BY 't' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY 'n' STARTING BY '' (word);
- LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-2-0' INTO TABLE `t1` FIELDS TERMINATED BY 't' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY 'n' STARTING BY '' (word);
- LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-3-0' INTO TABLE `t1` FIELDS TERMINATED BY 't' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY 'n' STARTING BY '' (word);
- LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-4-0' INTO TABLE `t1` FIELDS TERMINATED BY 't' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY 'n' STARTING BY '' (word);
- LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-5-0' INTO TABLE `t1` FIELDS TERMINATED BY 't' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY 'n' STARTING BY '' (word);
- --- Broken LOAD DATA --
- /*!40019 SET @@session.max_insert_delayed_threads=0*/;
- use test;
- SET TIMESTAMP=1000000000;
- insert into t1 values ("Alas");
- --- --database --
- /*!40019 SET @@session.max_insert_delayed_threads=0*/;
- SET INSERT_ID=1;
- --- --position --
- /*!40019 SET @@session.max_insert_delayed_threads=0*/;
- use test;
- SET TIMESTAMP=1000000000;
- insert into t1 values ("Alas");
- --- Remote --
- /*!40019 SET @@session.max_insert_delayed_threads=0*/;
- use test;
- SET TIMESTAMP=1000000000;
- 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 ();
- LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-1-1' INTO TABLE `t1` FIELDS TERMINATED BY 't' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY 'n' STARTING BY '' (word);
- LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-2-1' INTO TABLE `t1` FIELDS TERMINATED BY 't' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY 'n' STARTING BY '' (word);
- LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-3-1' INTO TABLE `t1` FIELDS TERMINATED BY 't' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY 'n' STARTING BY '' (word);
- LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-4-1' INTO TABLE `t1` FIELDS TERMINATED BY 't' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY 'n' STARTING BY '' (word);
- LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-5-1' INTO TABLE `t1` FIELDS TERMINATED BY 't' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY 'n' STARTING BY '' (word);
- --- Broken LOAD DATA --
- /*!40019 SET @@session.max_insert_delayed_threads=0*/;
- use test;
- SET TIMESTAMP=1000000000;
- insert into t1 values ("Alas");
- --- --database --
- /*!40019 SET @@session.max_insert_delayed_threads=0*/;
- SET INSERT_ID=1;
- --- --position --
- /*!40019 SET @@session.max_insert_delayed_threads=0*/;
- use test;
- SET TIMESTAMP=1000000000;
- insert into t1 values ("Alas");
- drop table t1, t2;