导入csv文件:
LOAD DATA INFILE 'F:/data0210/p1.csv'
INTO TABLE `test1_copy`
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY '\r\n';
导出csv文件:
SELECT * FROM `test1_copy`
INTO OUTFILE 'F:/data0210/p1.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY '\r\n'