首页 > 技术文章 > mysql从文件中导入数据

zhzhang 2016-04-25 16:32 原文

linux:

  load data infile '/tmp/dnslog.txt' into table dnslog_cnnic_cn fields terminated by ' ' lines terminated by '\n';

windows:

  load data local infile 'd:\dnslog_daily_nodes_total.sql' into table dnslog_cnnic_cn_nodes_total fields terminated by ' ' lines terminated by '\n';

 

推荐阅读