[DB-SIG] MySQLdb and INNODB tables
nathan-db-sig at geerbox.com
Wed Apr 6 22:35:55 CEST 2005
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?
More information about the DB-SIG