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
Posted on March 9, 2011, in Language References, Programming & Development and tagged import csv, mysql, reference. Bookmark the permalink. Leave a comment.
Leave a comment
Comments 0