SELECT * FROM projectall WHERE Namespacename IN ('assist',CrawlTeam','TM')INTO OUTFILE
'C:/ProgramData/MySQL/MySQL Server 5.7/data/test.csv' CHARACTER SET gbk FIELDS TERMINATED BY ',' LINES TERMINATED BY '' ;
- 注意目录格式
- 注意编码
- 文件在server端寻找
SELECT * FROM projectall WHERE Namespacename IN ('assist',CrawlTeam','TM')INTO OUTFILE
'C:/ProgramData/MySQL/MySQL Server 5.7/data/test.csv' CHARACTER SET gbk FIELDS TERMINATED BY ',' LINES TERMINATED BY '' ;