mysql 批量从本文件批量导入导出数据

导入: load data infile "c:/1.txt" into table test fields terminated by'|'

导出: -- 导出数据为文本文件

SELECT ML,DL,ZL,XL,MC,SM

INTO OUTFILE 'C:\DM_HY_EXPORT.TXT'

FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''''

LINES TERMINATED BY '\n'

FROM DM_HY;