[DB-SIG] MySQLdb and INNODB tables
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?
Network Security Operations Center
More information about the DB-SIG