MySQL mysqlimport Using a custom field-delimiter
Example
Given the text file employee.txt
1|Arthur Dent
2|Marvin
3|Zaphod Beeblebrox
$ mysqlimport --fields-terminated-by='|' mycompany employee.txt
Given the text file employee.txt
1|Arthur Dent
2|Marvin
3|Zaphod Beeblebrox
$ mysqlimport --fields-terminated-by='|' mycompany employee.txt
