Given the text file employee.txt

1|Arthur Dent 2|Marvin 3|Zaphod Beeblebrox

$ mysqlimport --fields-terminated-by='|' mycompany employee.txt