Re: execute multiple queries with mysql c++ connector
From: Axel Schwenke <axel.schwenke_at_gmx.de>
Date: Sat, 11 Mar 2017 00:38:21 +0100
Message-ID: <o9vd84$vui$1_at_dont-email.me>
>
> The proper question would be, "Do transactions have any affect on MyISAM
> databases?", and the answer to that would be "No. MySQL does not support
> transactions on MyISAM databases."
Date: Sat, 11 Mar 2017 00:38:21 +0100
Message-ID: <o9vd84$vui$1_at_dont-email.me>
On 10.03.2017 18:26, Lew Pitcher wrote:
> <tnp_at_invalid.invalid> wrote:
>
>> Further to this do transactions have ANY effect on C-ISAM style files?
>
> The proper question would be, "Do transactions have any affect on MyISAM
> databases?", and the answer to that would be "No. MySQL does not support
> transactions on MyISAM databases."
Another way to phrase the answer would be: in MySQL transaction support is implemented at the storage engine layer. InnoDB is the only shipped engine in MySQL that supports transactions. There are other (third-party) engines with transaction support (i.e. TokuDB). The MyISAM engine in MySQL does not support transactions (and never will). Received on Sat Mar 11 2017 - 00:38:21 CET