Changes between Version 6 and Version 7 of jazz/13-12-21


Ignore:
Timestamp:
Dec 21, 2013, 3:29:42 PM (10 years ago)
Author:
jazz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • jazz/13-12-21

    v6 v7  
    5050mysqlimport -u root -p --lines-terminated-by="\r\n" --fields-terminated-by="," Dbname csvfile.csv
    5151}}}
     52 * http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html
     53  * If you use LOAD DATA LOCAL in Perl scripts or other programs that read the [client] group from option files, you can add the local-infile=1 option to that group. However, to keep this from causing problems for programs that do not understand local-infile, specify it using the loose- prefix:
     54{{{
     55    [client]
     56    loose-local-infile=1
     57}}}
     58  * If LOAD DATA LOCAL is disabled, either in the server or the client, a client that attempts to issue such a statement receives the following error message:
     59{{{
     60    ERROR 1148: The used command is not allowed with this MySQL version
     61}}}
    5262 * 執行 Sqoop 連到 MySQL 匯入資料的測試
    5363{{{