擅长:python、mysql、java
<p>改进比尔曼的回答:</p>
<pre class="lang-py prettyprint-override"><code>conn = pyodbc.connect(' ... ')
cursor = conn.cursor()
cursor.execute('SELECT ...')
col_headers = [ i[0] for i in cursor.description ]
rows = [ list(i) for i in cursor.fetchall()]
df = pd.DataFrame(rows, columns=col_headers)
df.to_csv("test.csv", index=False)
</code></pre>