Re: Where does MySQLdb put inserted data?

From	Mark Lawrence <breamoreboy@yahoo.co.uk>
Subject	Re: Where does MySQLdb put inserted data?
Date	2013-10-05 12:39 +0100
References	<524E7081.3080308@bluewin.ch> <8mhu49dobl4dg99am35dcri2qegp0ssbrc@4ax.com> <524FD027.6040202@bluewin.ch>
Newsgroups	comp.lang.python
Message-ID	<mailman.742.1380973172.18130.python-list@python.org> (permalink)

Show all headers | View raw

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

Reminds me of the people who've never had an accident but have seen 
thousands in their rear view mirror.  Perhaps the driver here 
http://www.bbc.co.uk/news/uk-england-hampshire-24367601 ?

-- 
Roses are red,
Violets are blue,
Most poems rhyme,
But this one doesn't.

Mark Lawrence

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Where does MySQLdb put inserted data? Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-10-05 12:39 +0100

csiph-web