Mysql

1.导出
1.1 mysql命令导出
select * form tablename into outfile 'filename'[option]
fields terminated by '\t'       #字段分割符,默认为制表符‘\t’
[optionally] enclose by 'char'  #optionally表示字段为数值不用包围，默认为空
escaped by 'char'               #制定转义字符，默认为‘\’
lines starting by 'string'      #每行前加上，默认为''
terminated by 'string'          #行结束符，默认为'\n'
;