擅长:python、mysql、java
<p>您可以导入错误类:</p>
<pre><code>from pymysql.err import InternalError
</code></pre>
<p>添加计数器:</p>
<pre><code>fileIndex = 0
</code></pre>
<p>然后查看文件是否已存在:</p>
<pre><code>try:
statm = "SELECT * FROM omniacademp INTO OUTFILE '/TEMP/HI.CSV' FIELDS TERMINATED BY ',' ENCLOSED BY ''"
cursor.execute(statm)
except InternalError:
statm = "SELECT * FROM omniacademp INTO OUTFILE '/TEMP/HI ({}).CSV' FIELDS TERMINATED BY ',' ENCLOSED BY ''".format(fileIndex)
cursor.execute(statm)
fileIndex += 1
</code></pre>