擅长:python、mysql、java
<p><strong>Python DB API默认情况下禁用自动提交</strong></p>
<p>从谷歌粘贴(第一页,第二个结果)</p>
<blockquote>
<p>MySQL :: MySQL 5.0 Reference Manual :: 13.2.8 The InnoDB ...
<strong>By default, MySQL starts the session for each new connection with autocommit ...</strong>
<a href="http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html" rel="nofollow">dev.mysql.com/.../innodb-transaction-model.html</a></p>
</blockquote>
<p><strong>但是</strong></p>
<p>显然Python是以非自动提交模式启动MySQL的,请参见:<br/>
<a href="http://www.kitebird.com/articles/pydbapi.html" rel="nofollow">http://www.kitebird.com/articles/pydbapi.html</a></p>
<p>从文章中:</p>
<blockquote>
<p>The connection object commit() method commits any outstanding changes in the current transaction to make them permanent in the database. In DB-API, connections begin with <strong>autocommit mode disabled</strong>, so you must call commit() before disconnecting or changes may be lost.</p>
</blockquote>
<p>可怜虫,不知道如何克服这一点,我不想通过猜测把你引入歧途。
我建议提出一个新问题,题为:</p>
<p>如何在MySQL python DB-API中启用自动提交模式</p>
<p>祝你好运</p>