# mysql -u root -p
mysql> use test;
mysql> LOAD DATA LOCAL INFILE '/home/darek/test.txt'
-> INTO TABLE employee
-> FIELDS TERMINATED BY '\t'
-> LINES TERMINATED BY '\n'
-> (empno, ename, job);
Query OK, 3 rows affected (0.01 sec)
Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
mysql> select * from employee;
+-------+------------+-----------+
| empno | ename | job |
+-------+------------+-----------+
| 100 | John Doe | DBA |
| 200 | John Smith | Sysadmin |
| 300 | Raj Patel | Developer |
+-------+------------+-----------+
3 rows in set (0.00 sec)
Original post from: http://www.thegeekstuff.com/2008/10/import-and-upload-data-to-mysql-tables-using-mysqlimport/