On 10/05/2013 12:55 AM, Dennis Lee Bieber wrote:
On Fri, 04 Oct 2013 09:38:41 +0200, "F.R." <[email protected]> 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
