Mysql导入数据

[size&＃61;xx-large][b][color&＃61;brown]Mysql导入数据[/color][/b][/size]



一、介绍

load data [low_priority] [local] infile &＃39;file_name txt&＃39; [replace | ignore]

into table tbl_name

[fields

[terminated by&＃39;t&＃39;]

[OPTIONALLY] enclosed by &＃39;&＃39;]

[escaped by&＃39;\&＃39; ]]

[lines terminated by&＃39;n&＃39;]

[ignore number lines]

[(col_name, )]





二、demo&＃xff1a;

1.sql.txt


11,398875193&＃64;qq.com,ewf_momo&＃64;foxmail.com,"导入成功",2013-03-09 00:45:01
12,398875193&＃64;qq.com,ewf_momo&＃64;foxmail.com,"导入成功",2013-03-09 00:45:01
13,398875193&＃64;qq.com,ewf_momo&＃64;foxmail.com,"导入成功",2013-03-09 00:45:01
14,398875193&＃64;qq.com,ewf_momo&＃64;foxmail.com,"导入成功",2013-03-09 00:45:01
15,398875193&＃64;qq.com,ewf_momo&＃64;foxmail.com,"导入成功",2013-03-09 00:45:01
16,398875193&＃64;qq.com,ewf_momo&＃64;foxmail.com,"导入成功",2013-03-09 00:45:01




2.语句&＃xff1a;


LOAD DATA INFILE &＃39;D:\\TestDataDemo\\sql.txt&＃39;
INTO TABLE e_mails
FIELDS TERMINATED BY &＃39;,&＃39;
enclosed by &＃39;"&＃39;
lines terminated by &＃39;\r\n&＃39;
(id,outbox,inbox,status,send_time);




参考&＃xff1a;

1.[url]http://www.lsanotes.cn/load-data-local-infile[/url]

2.[url]http://www.58blo.com/?p&＃61;163[/url]

3.[url]http://blog.163.com/weiwohappy&＃64;126/blog/static/7326333020129300644683/[/url]