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 pro
On Apr 6, 2005 4:19 PM, Dave Rogers <[EMAIL PROTECTED]> wrote:
> I need to use MySQL INNODB tables for transactions, however, I have run
> into a problem. I can do SELECTS on the INNODB tables just fine but
> INSERTS and UPDATES do not work. No error is generated. I tried the same
> code using Pyth
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
I need to use MySQL INNODB tables for transactions, however, I have run
into a problem. I can do SELECTS on the INNODB tables just fine but
INSERTS and UPDATES do not work. No error is generated. I tried the same
code using Python interactively and Python returns "1L" for each line I
try to insert
