Donec at mattis erat! Duis sed massa eget eros gravida vulputate nec ut ipsum.

Loading CSV files in MySQL Featured

Many times you will want to load a csv file into a database. If your table is the same structure as the csv file there are some very quick ways to load the file into the db with out having to load it into an array and do foreach loops for each row. The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. The file name must be given as a literal string.

LOAD DATA LOCAL INFILE "/location-of.csv" INTO TABLE csv.table FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

Sometimes when exporting from a windose machine you will need to use the code below. Windows is bad about inserting poorly formated line breaks.

LOAD DATA LOCAL INFILE "/location-of.csv" INTO TABLE csv.table FIELDS OPTIONALLY ENCLOSED BY '\"' TERMINATED BY ',' LINES TERMINATED BY '\r\n'
Last modified onThursday, 28 January 2016 04:08
  • Rate this item
    (0 votes)
  • Published in MySQL
  • Read 4055 times

Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.

back to top

Latest News

Social GK5

Any data to display