mysql导入导出CSV

mysql导出csv：
select * from test_info   
into outfile ‘/tmp/test.csv‘   
fields terminated by ‘,‘　　　 ------字段间以,号分隔
optionally enclosed by ‘"‘　　 ------字段用"号括起
escaped by ‘"‘   　　　　　　  ------字段中使用的转义符为"
lines terminated by ‘\r\n‘;　　------行以\r\n结束

mysql导入csv：
load data infile ‘/tmp/test.csv‘   
into table test_info    
fields terminated by ‘,‘  
optionally enclosed by ‘"‘ 
escaped by ‘"‘   
lines terminated by ‘\r\n‘;