Daily Archives: December 9, 2011


How to import a delimited file with mysql

Using Mac OS X on the command line, log into mysql and select your database. Then run the following for a tab delimited file located on your desktop:

load data LOCAL infile ‘/Users/YOURNAME/Desktop/standards.txt’ into table TABLE_NAME fields terminated by “\t” lines terminated by “\r”