using mysqlimport : mysqlimport « Command MySQL « SQL / MySQL






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

using mysqlimport

     

% mysqlimport --local --lines-terminated-by="\r\n" --fields-terminated-by="," --fields-enclosed-by="\"" 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.If you use mysqlimport, command-line options provide the format specifiers.
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