博客园 首页 私信博主 显示目录 隐藏目录 管理 动画

mysql load data local infile

 In the cargomysql> LOAD DATA LOCAL INFILE T/etc/passwd' INTO TABLE mpasswd;

For the MySQL client local data loading is disabled by default.

Enable or disable it clear, use --local-infile=0 or --local-infile[=1] options

For information on mysqlimport client local data loading is disabled by default.

Enable or disable it clear, use --local=0 or --local[=1] options

 load data local infile 'D:/data.txt' into talbe pet lines terninated by '\r\n' ignore 1 lines;

 

posted @ 2022-07-18 20:03  CHANG_09  阅读(60)  评论(0)    收藏  举报