如何使用命令行将SQL查询导出到TXT [英] How to Export SQL Query to TXT Using Command Line

问题描述

我想从linux的命令行导出 select * from table 结果到一个文本文件。我应该怎么做？

I want to export select * from table results to a text file from the command line in linux. How should I do this?

谢谢，
Jean

Thanks, Jean

推荐答案

请参阅链接

您只需要将其添加到查询中

you only need to add this to the query

select * from table INTO OUTFILE '/tmp/myfilename.txt'

您可以将其改进为csv文件（在excel后使用）

you can improve this to csv file (using it in excel latter)

like：

INTO OUTFILE '/tmp/myfilename.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

这篇关于如何使用命令行将SQL查询导出到TXT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！