MySql 文件导入导出

select * FROM zhilianzhaopin4

INTO OUTFILE 'G:/test.csv' --------输出位置

fields terminated by '@@' --------字段用@@分割

optionally enclosed by '"'　　------字段用"号括起（单引号包一个双引号）

escaped by '"' 　　　　　　------字段中使用的转义符为"

lines terminated by '\r\n';　　------行以\r\n结束

二、csv文件导入

load data infile '/tmp/test.csv'

into table test_info

fields terminated by ','

optionally enclosed by '"'

escaped by '"'

lines terminated by '\r\n';

巴特西