Nicholas Cheek

LITTLE ROCK WEB DEVELOPER

Loads large csv file for importing

================================================
Import Tables after Truncating previous tables and ignoring the header line
================================================
Truncate Table myTable; 
LOAD DATA LOCAL INFILE '/var/csv/SO.csv' INTO TABLE mytable FIELDS TERMINATED BY ','  ENCLOSED BY '"'  LINES TERMINATED BY '\r\n' IGNORE 1 LINES;

LITTLE ROCK WEB DEVELOPER

Living the dream.

nick@nicholascheek.com