mysql中 select ....into outfile 导出数据

Select *from 表名 into outfile 'C/.../.../.../xxx.txt '

fields terminated by ' ' 字段值用什么隔开

Optionally enclosed by ''' ' 字段是字符用双引号标注

Lines terminated by '' 每行以什么结束

Load data infile 'C/.../.../.../xxx.txt ' into 表名

fields terminated by ' ' 字段值用什么隔开

Optionally enclosed by ''' ' 字段是字符用双引号标注

Lines terminated by '' 每行以什么结束