企业资讯
- 企业新闻
- 行业文章

mysql一条语句导出数据

这两天要处理一些数据，用一些数据库管理工具比如navicat for mysql 、 sqlyog、以及phpmyadmin之类的工具，试了很多，发现都导入不全，

蛋碎了，最后还是选择写SQL语句来搞吧，mysql里面有个load data infile 很强大，可以高速从文件导入数据，而且设置好了不会丢失数据。

导入示例：

 load data  infile ‘C:seay.csv’ into table 表名 CHARACTER SET utf8 fields terminated by ‘;’ optionally enclosed by ‘”‘ lines terminated by ‘rn’ (列1,列2)

load data infile ‘C:seay.csv’ into table 表名

CHARACTER SET utf8

fields terminated by ‘;’

optionally enclosed by ‘”‘

lines terminated by ‘rn’ (列1,列2)

导出示例：

 select * from test_info    into outfile ‘C:/seay.csv’    fields terminated by ‘,’ optionally enclosed by ‘”‘ escaped by ‘”‘    lines terminated by ‘rn’;

select * from test_info

into outfile ‘C:/seay.csv’

fields terminated by ‘,’ optionally enclosed by ‘”‘ escaped by ‘”‘

lines terminated by ‘rn’;

说明：

 CHARACTER SET utf8  设置编码  fields terminated by ‘;’  分隔标识符 optionally enclosed by ‘”‘  内容以双引号包住  lines terminated by ‘rn’ (列1,列2)  换行rn

CHARACTER SET utf8 设置编码

fields terminated by ‘;’ 分隔标识符

optionally enclosed by ‘”‘ 内容以双引号包住

lines terminated by ‘rn’ (列1,列2) 换行rn

link:http://www.cnseay.com/3142/

本文由网络安全攻防研究室（www.91ri.org）信息安全小组收集整理，转载请注明出处。

鸿大千秋网站建设团队敬上