in reply to DBI with MySQL InnoDB tables troubles

WHAT A ...

This was "only" the commit... with $dbh->commit everything works fine...
I turned on the Autocommit in the dbh creation and everything also worked.

Strange that it worked with MyISAM tables without the commit, and not with InnoDB tables.

Thank you everybody for your help.

Replies are listed 'Best First'.
Re^2: DBI with MySQL InnoDB tables troubles
by andreas1234567 (Vicar) on Jul 27, 2007 at 14:06 UTC
    Strange that it worked with MyISAM tables without the commit, and not with InnoDB tables.
    Isn't that because MyISAM tables are non-transactional (i.e they do not support commit, rollback), while InnoDB are transactional? See this (dev.mysql.com) article.
    --
    Andreas
[reply]

In Section Seekers of Perl Wisdom