[DB-SIG] MySQLdb and INNODB tables

Nathan Clegg 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 mailing list