导入:
load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/XXXXXXXXX'
replace into table 表名 (导入字段);
导出:
SELECT DISTINCT(导出字段) FROM 表名
into outfile 'D:/1.txt' lines terminated by '\r\n' ;
导入:
load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/XXXXXXXXX'
replace into table 表名 (导入字段);
导出:
SELECT DISTINCT(导出字段) FROM 表名
into outfile 'D:/1.txt' lines terminated by '\r\n' ;