Blog Archives

MySQL Quick Reference

Import CSV:

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

References
http://www.pantz.org/software/mysql/mysqlcommands.html
http://support.modwest.com/content/6/253/en/how-do-i-import-delimited-data-into-mysql.html