Given the tab-separated file employee.txt
1
\t
Arthur Dent
2\t
Marvin
3\t
Zaphod Beeblebrox
$ mysql --user=user --password=password mycompany -e 'CREATE TABLE employee(id INT, name VARCHAR(100), PRIMARY KEY (id))'
$ mysqlimport --user=user --password=password mycompany employee.txt