Problem w/ MySQLdb

Victor Subervi victorsubervi at gmail.com
Tue Feb 15 23:10:29 CET 2011


It's been too long since I've worked on this. Yep, I forgot to commit.
Thanks,
Beno

On Tue, Feb 15, 2011 at 5:21 PM, Jerry Hill <malaclypse2 at gmail.com> wrote:

> On Tue, Feb 15, 2011 at 3:24 PM, Victor Subervi <victorsubervi at gmail.com>
> wrote:
> > It builds the table but fails from the first insertion. Trying to insert
> > using that code directly in MySQL does indeed work. Why?
>
> In what way does it fail?  Does it give you a stack trace, and if so,
> what does it say?  Does it create the table, but not populate any
> data?  If that's the case, you probably need to call commit() after
> you do your inserts.
>
> I'm not familiar with the MySQLDB module in particular, but python
> database adapters typically do not autocommit, unless you explicitly
> ask for that behavior.
>
> --
> Jerry
> --
> http://mail.python.org/mailman/listinfo/python-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20110215/841ee857/attachment.html>


More information about the Python-list mailing list