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? _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig