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 - [email protected]
http://mail.python.org/mailman/listinfo/db-sig