MySQL Tips: LOAD DATA INFILE example - importing data from csv into mysql

Sunday, April 17, 2005

LOAD DATA INFILE "/home/mysql/data/my_table.csv" INTO TABLE my_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';

MDM said...: Very good tip! Thanks!!; 6:23 PM
Anonymous said...: Thanks a lot.; 3:19 AM
Jason said...: Thanks very much. Very useful example.; 2:22 PM
Arend van der Kolk said...: simple but excellent in the eyes of a newbie, ;-) thx; 7:05 AM
check odds said...: but that path with home what it means? where i need to place that file to take it?; 5:45 AM
Anonymous said...: But I got an error message:
ERROR 13 (HY000): Can't get stat of '/var/lib/mysql TAIR10_functional_descriptions_no_headers.txt.tab' (Errcode: 2)

It is said related to the permission issue to mysql client or the user when I googled, but I checked the permission, it is rw-. Any clue? Thanks a lot!; 1:53 PM
Anonymous said...: Thank you so much - very helpful! My loaded csv file data was appearing as zeroes and nulls until I read this blog and realised I hadn't specified the comma delimiter.; 1:34 AM