mysql导入、导出数据
上一篇 /
下一篇 2012-02-24 15:38:00
/ 个人分类:数据库
load data
从外部文件导入数据到表中
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number LINES]
[(col_name_or_user_var,...)]
[SET col_name = expr,...]
51Testing软件测试网h
_o*b{vd
例:
txt文件
id,name
1,aaa
2,bbb
51Testing软件测试网Xf)[%} K$W8Y
load data infile 'f:\123.txt'
into table mytest
fields terminated by ','
ignore 1 lines
(id,name);
jJpdQ@n0
select ……into outfile
把数据表导出到外部文件
6jYT(}DR)Y9Q(m0
select id,name into outfile 'f:\123.txt'
fields terminated by ','
lines terminated by '\n'
from mytest;
收藏
举报
TAG: