[DB-SIG] MySQLdb and INNODB tables

Dave Rogers David.Rogers at mci.com
Wed Apr 6 23:34:58 CEST 2005


Thanks! That was it. I incorrectly assumed that I could operate without
transactions on InnoDB tables where I did not explicitly need them.


On Wed, 2005-04-06 at 13:35 -0700, Nathan Clegg wrote:
> InnoDB tables are transactional.  Are you committing your transactions
> after inserts and deletes?  This isn't necessary on MyISAM tables.
> >>>>> "Dave" == Dave Rogers <David.Rogers at mci.com> writes:
>     Dave> I need to use MySQL INNODB tables for transactions, however,
>     Dave> I have run into a problem. I can do SELECTS on the INNODB
>     Dave> tables just fine but INSERTS and UPDATES do not work. No
>     Dave> error is generated. I tried the same code using Python
>     Dave> interactively and Python returns "1L" for each line I try to
>     Dave> insert but in fact nothing is ever inserted. My Python code
>     Dave> works perfectly with MyISAM tables.
>     Dave> Am I just not holding my mouth right or what?
Dave Rogers
Network Security Operations Center

More information about the DB-SIG mailing list