Import CSV File into MySQL

LOAD DATA INFILE ‘/var/lib/mysql/data.csv’ INTO TABLE MyTable FIELDS TERMINATED BY ‘\t’ LINES TERMINATED BY ‘\n’;

Advertisements