On 10/05/2013 12:55 AM, Dennis Lee Bieber wrote:
On Fri, 04 Oct 2013 09:38:41 +0200, "F.R." <anthra.nor...@bluewin.ch>
declaimed the following:

<snip convoluted unformatted stuff>

        MySQLdb, as with all DB-API compliant adapters, does NOT do
"auto-commit" -- you MUST execute a con.commit() after any query (sequence)
that modifies data. Without it, closing the connection will invoke a
ROLLBACK operation, removing any attempted changes.

That's it! It works! Thank you sooo much. A miracle how I could go without commits for years and never have missing data. Anyway, another lesson learned . . .

Thanks

Frederic

--
https://mail.python.org/mailman/listinfo/python-list

Reply via email to