Fork me on GitHub

mysql into outfile 导出

 <sql> into outfile 'xxx.txt' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';

 <sql> 表示正常的查询语句。导出的txt文件在mysql安装目录的data/<database>中。

 

posted @ 2019-02-25 20:23  北斗2016  阅读(1890)  评论(0编辑  收藏  举报