How do I import delimited data into MySQL?

How do I import delimited data into MySQL?

mysql> load data local infile "xxxrs.txt" into table data_table; this work successfully make sure that rs.txt is located at 'MySQL Sverver 6.0\bin'


LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3);


http://www.svdeals.com/