When you run the mysqlimport command, you must specify these formatting characters : mysqlimport « Command MySQL « SQL / MySQL






  1. SQL / MySQL
  2. Command MySQL
  3. mysqlimport

When you run the mysqlimport command, you must specify these formatting characters

     

mysqlimport --user=root --password=pw1 --fields-terminated-by="," --fieldsenclosed-
by="*" test "c:\mysql\data\test\CDs3.sql"








Related examples in the same category

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.Specify a double quote within a double-quoted string by escaping it