擅长:python、mysql、java
<p>考虑使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_sql.html" rel="nofollow">dtype</a>参数,该参数接受字典将数据帧列名映射到指定的<a href="http://docs.sqlalchemy.org/en/rel_0_5/reference/sqlalchemy/types.html" rel="nofollow">sqlalchemy data types</a>。您可以尝试<code>Varchar</code>:</p>
<pre><code>import sqlalchemy
df.to_sql(table_name, engine, schema='dbo',
index=True, index_label='IdColumn',
if_exists='replace',
dtype={'IdColumn': sqlalchemy.types.VARCHAR(length=255)})
</code></pre>
<p>或泛型<code>String</code>类型,指定长度:</p>
^{pr2}$