SQL/MySQL/Backup Load/Load Data Into Table
Load data in txt file into database
<source lang="sql">
Drop table Bird; CREATE TABLE Bird (
name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE
);
INSERT INTO Bird VALUES ("BlueBird","Joe","Car","f","1999-03-30",NULL);
/* Suppose that your Bird records can be described as shown here. (Observe that MySQL expects dates in "YYYY-MM-DD" format; this may be different from what you are used to.
- /
name owner species sex birth death Blue Joe cat f 1993-02-04 Yellow Yin cat m 1994-03-17 Red Richard dog f 1989-05-13
/* Note that if you created the file on Windows with an editor that uses \r\n as a line terminator, you should use:
- /
LOAD DATA LOCAL INFILE "/path/Bird.txt" INTO TABLE Bird LINES TERMINATED BY "\r\n";
</source>
load text data into table
<source lang="sql">
LOAD DATA INFILE "/textFileName.txt" INTO TABLE quackers FIELDS TERMINATED BY ";" LINES TERMINATED BY "\r\n" IGNORE 1 LINES; /*
Colons, by using ":" Semicolons, by using ";" Spaces, by using " "
- /
</source>