擅长:python、mysql、java
<p>您需要在插入操作之后提交并关闭数据库连接。
假设<code>sql</code>是您的查询字符串,请执行以下操作:</p>
<pre><code>try:
# Execute the SQL command
cursor.execute(sql)
# Commit your changes in the database
db.commit()
except:
# Rollback in case there is any error
db.rollback()
# disconnect from server
db.close()
</code></pre>
<p>请查看以下示例:
<a href="http://www.tutorialspoint.com/python/python_database_access.htm" rel="nofollow">http://www.tutorialspoint.com/python/python_database_access.htm</a></p>