擅长:python、mysql、java
<p>现代Pandas版本期望<a href="http://docs.sqlalchemy.org/en/latest/core/engines.html#microsoft-sql-server" rel="noreferrer">^{<cd1>}</a>作为连接,因此使用SQLAlchemy:</p>
<pre><code>from sqlalchemy import create_engine
con = create_engine('mssql+pyodbc://username:password@myhost:port/databasename?driver=SQL+Server+Native+Client+10.0')
</code></pre>
<p>然后:</p>
<pre><code>df_EVENT5_16.to_sql('MODREPORT', con, if_exists='replace')
</code></pre>
<p>来自<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_sql.html" rel="noreferrer">DataFrame.to_sql() docs</a>:</p>
<blockquote>
<p><strong>con</strong> : SQLAlchemy engine or DBAPI2 connection (legacy mode) </p>
<p>Using SQLAlchemy makes it possible to use any DB supported by that library.</p>
<p>If a DBAPI2 object, only sqlite3 is supported.</p>
</blockquote>