Load data in txt file into database
Drop table Bird;
CREATE TABLE Bird (
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';
Related examples in the same category