mysql 导入导出csv命令

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.youkuaiyun.com/sara_yhl/article/details/6850107