develooper Front page | perl.dbi.users | Postings from August 2006

RE: Re: AutoCommit does not work

Thread Previous
From:
Garrett, Philip
Date:
August 22, 2006 10:58
Subject:
RE: Re: AutoCommit does not work
Message ID:
D9C13100F14E4C4795A1E83B125B40350232B506@MSCEXCHS02.man.co
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

Thread Previous


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About