CODEWITHSUNDEEP
mysqltransactionsmyisam
user3113782
user3113782

Reputation: 77

InnoDB behavior for a transaction updating MyISAM and InnoDB tables

I read most of example InnoDB on this website but I have no clue for InnoDB behavior.

As far As I found out 

START TRANSACTION;

Is declaring this is a transaction connection. It's OK till here. NOW I have 3 tables:

Sequence of updates:

SET AUTOCOMMIT=0
START TRANSACTION;
UPDATE tbl2 SET column=1 WHERE (SELECT clumn FROM tbl WHERE column2=1);
UPDATE tbl3 SET column=1;
Rollback;

What will happen to MyISAM table is it rollback or only tbl3 and tbl1 will be rollback?

Upvotes: 2

Views: 84

Answers (1)

Bill Karwin
Bill Karwin

Reputation: 562230

MyISAM doesn't know anything about transactions, and it cannot roll back changes.

So if you roll back, the changes to tbl3 will be discarded, but the changes to tbl2 will remain.

Upvotes: 1

Related Questions