|
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';
|