Nathan, Thanks! That was it. I incorrectly assumed that I could operate without transactions on InnoDB tables where I did not explicitly need them.
Best, dave 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 <[EMAIL PROTECTED]> 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 777-6522 _______________________________________________ DB-SIG maillist - [email protected] http://mail.python.org/mailman/listinfo/db-sig
