If you use mysqlimport, command-line options provide the format specifiers. : mysqlimport « Command MySQL « SQL / MySQL






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

If you use mysqlimport, command-line options provide the format specifiers.

     

% mysqlimport --local myDatabase mytbl.txt
% mysqlimport --local --fields-terminated-by=":" --lines-terminated-by="\r" \ myDatabase mytbl.txt








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.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