MYSQL mysqlimport
Basic usage
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
Using a custom field-delimiter
Given the text file employee.txt
1|Arthur Dent
2|Marvin
3|Zaphod Beeblebrox
$ mysqlimport --fields-terminated-by='|' mycompany employee.txt
Using a custom row-delimiter
This example is useful for windows-like endings:
$ mysqlimport --lines-terminated-by='\r\n' mycompany employee.txt