mysql select into outfile

来源:互联网 发布:java商城项目需要多久 编辑:程序博客网 时间:2024/06/04 14:21
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端寻找
0 0
原创粉丝点击