MySQL 如何使用 INTO OUTFILE 附加到文件? [英] MySQL how do you append to a file with INTO OUTFILE?

问题描述

我有以下代码:

SELECT * INTO OUTFILE'~/TestInput/Results.csv'      
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
FROM Results;

期望的结果是不断追加到 Results.csv

推荐答案

您可以合并结果并立即写入.TEE 将记录可能不理想的所有内容.在你的情况下:

You can merge results and write at once. TEE will log everything which might not be desirable. In your case:

SELECT * FROM Results UNION 
SELECT * FROM Results INTO OUTFILE '~/TestInput/Results.csv';

这篇关于MySQL 如何使用 INTO OUTFILE 附加到文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！