Mega Code Archive

 

Categories / MySQL / Backup Load

 

IGNORE is often useful with files generated by external sources

LOAD DATA LOCAL INFILE 'mytbl.txt' INTO TABLE mytbl FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r' IGNORE 1 LINES;