Mega Code Archive

 

Categories / MySQL / Backup Load

 

The syntax for a command to use a comma-separated text file, saved in a Windows format

LOAD DATA INFILE '<full_path_to_text_file>' INTO TABLE <table_name> FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';