我要出口select * from table
从 Linux 命令行将结果保存到文本文件。我该怎么做?
谢谢,
让
look at link http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/
您只需要将其添加到查询中
select * from table INTO OUTFILE '/tmp/myfilename.txt'
你可以将其改进为csv文件(稍后在excel中使用它)
like :
INTO OUTFILE '/tmp/myfilename.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)