擅长:python、mysql、java
<p>可以使用以下查询将查询结果放入文件<code>/tmp/some_filename.txt</code>:</p>
<pre><code>SELECT dbx, dby, SQRT(
POW(69.1 * (dbx - userx), 2) +
POW(69.1 * (usery - dby) * COS(latitude / 57.3), 2)) AS distance
FROM TableName HAVING distance < 125 ORDER BY distance
INTO OUTFILE '/tmp/some_filename.txt'
</code></pre>
<p>如果要使用分隔符和引号字符,请添加以下内容:</p>
<pre><code>FIELDS TERMINATED BY ','
ENCLOSED BY '"'
</code></pre>
<p>如果要为输出文件添加行终止符:</p>
<pre><code>LINES TERMINATED BY '\n'
</code></pre>