October 2002
Intermediate to advanced
1024 pages
27h 26m
English
You need to load a file that is in CSV format.
Just add the appropriate format-specifier clauses to your
LOAD DATA statement.
Datafiles in CSV format contain values that are
delimited by commas rather than tabs and that may be quoted with
double quote characters. For example, a CSV file
mytbl.txt containing lines that end with
carriage return/linefeed pairs can be loaded into
mytbl as follows using LOAD
DATA:
mysql>LOAD DATA LOCAL INFILE 'mytbl.txt' INTO TABLE mytbl->FIELDS TERMINATED BY ',' ENCLOSED BY '"'->LINES TERMINATED BY '\r\n';
Or like this using mysqlimport:
%mysqlimport --local --lines-terminated-by="\r\n" \--fields-terminated-by="," --fields-enclosed-by="\"" \cookbook mytbl.txt