mysqlimport « Command MySQL « SQL / MySQL

1.LOAD DATA assumes the table is located in the current database unless you specify the database name explicitly.
2.If you use mysqlimport, command-line options provide the format specifiers.
3.using mysqlimport
4.When you run the mysqlimport command, you must specify these formatting characters
5.Specify a double quote within a double-quoted string by escaping it