Mysql导入数据

Mysql导入数据

一、介绍
load data [low_priority] [local] infile 'file_name txt' [replace | ignore]
into table tbl_name
[fields
[terminated by't']
[OPTIONALLY] enclosed by '']
[escaped by'\' ]]
[lines terminated by'n']
[ignore number lines]
[(col_name,   )]



二、demo：
1.sql.txt

11,[e-mail],[e-mail],"导入成功",2013-03-09 00:45:01
12,[e-mail],[e-mail],"导入成功",2013-03-09 00:45:01
13,[e-mail],[e-mail],"导入成功",2013-03-09 00:45:01
14,[e-mail],[e-mail],"导入成功",2013-03-09 00:45:01
15,[e-mail],[e-mail],"导入成功",2013-03-09 00:45:01
16,[e-mail],[e-mail],"导入成功",2013-03-09 00:45:01

2.语句：

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

参考：
1.http://www.lsanotes.cn/load-data-local-infile
2.http://www.58blo.com/?p=163
3.http://blog.163.com/weiwohappy@126/blog/static/7326333020129300644683/