学习 MySQL中导入 导出CSV

学习 MySQL中导入 导出CSV

http://blog.csdn.net/sara_yhl/article/details/6850107    速度是很快的

  1. 导出
select * from test_info
into outfile '/tmp/test.csv'
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '\r\n';
  1. 导入
load data infile '/tmp/test.csv'
into table test_info
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '\r\n';

如果是远程连接mysql,可能会报错,可以试试 load data local infile …..

如果使用工具的话,一般更简单,比如使用navicat , workbench等

workbench可参考官方文档: 
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html

http://www.jianshu.com/p/d330edb61fe2 
http://blog.csdn.net/sara_yhl/article/details/6850107

上一篇:VC++ 使用ShellExecute函数调用邮箱客户端发送邮件(可以带附件)


下一篇:精华阅读第 9 期 |滴滴出行 iOS 客户端架构演进之路