Mega Code Archive

 

Categories / MySQL / Backup Load

 

To specify a file format explicitly, use a FIELDS clause to describe the characteristics of fields within a line

LOAD DATA LOCAL INFILE 'mytbl.txt' INTO TABLE mytbl FIELDS TERMINATED BY ':' LINES TERMINATED BY '\r';