RE: Re: AutoCommit does not work

Artem Harutyunyan wrote:
Hi,

Are you using a table type in mysql that supports transactions?

Well, I am not sure, how can I check it ?

mysql> show table status like '%transaction%';

The second column (engine) is what you're interested in... needs to be
InnoDB to support transactions.

Regards,
Philip
.

Relevant Pages

  • Re: database in python ?
    ... Transactions only supported on slow database types like innodb. ... If you ever tried it you cannot say that mysql supports transactions. ... also slower than firebird if you do some real work. ...
    (comp.lang.python)
  • Re: using php to move rows from text file into mysql table
    ... I used phpmyadmin to run an sql to insert a record into the table. ... INSERT INTO transactions ... MySQL will accept 2 or 4 digit years, ... the insertion of the quotes around $dateandtime allowed it to be accepted. ...
    (comp.lang.php)
  • Re: php or asp.net for this?
    ... >> I don't know how you can just flat out recommend MySQL for the ... MySQL 4.1 is still alpha release, ... > 2-phase commit required for distributed transactions. ... MySQL beat SQL Server, DB2, and Sybase. ...
    (comp.lang.php)
  • Re: Question: database commit
    ... MySQL RDBM does not correctly implement transactions, and so "non-committed" updates WILL affect the select in another connection. ... InnoDB does support transactions and defaults to repeatable read isolation level. ...
    (comp.lang.java.programmer)
  • Re: database in python ?
    ... > Transactions only supported on slow database types like innodb. ... > If you ever tried it you cannot say that mysql supports transactions. ... Message: Cannot add or update a child row: a foreign key constraint ...
    (comp.lang.python)