LOAD DATA assumes the table is located in the current database unless you specify the database name explicitly. : mysqlimport « Command MySQL « SQL / MySQL






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

LOAD DATA assumes the table is located in the current database unless you specify the database name explicitly.

     

% mysqlimport --local myDatabase mytbl.txt








Related examples in the same category

1.If you use mysqlimport, command-line options provide the format specifiers.
2.using mysqlimport
3.When you run the mysqlimport command, you must specify these formatting characters
4.Specify a double quote within a double-quoted string by escaping it