Import a plain CSV file into MySQL

This assumes you have already created the required table with all of the correct fields. Also this assumes you are using , as the field separator.

LOAD DATA INFILE 'filename.txt' INTO table_name FIELDS TERMINATED BY ',';