Tag Archives: transactions

MySQL: Transactions in MyISAM and InnoDB

Test

CREATE TABLE `t01` (
`column_of_t01` int(11) DEFAULT NULL
) ENGINE=MyISAM;

CREATE TABLE `t02` (
`column_of_t02` int(11) DEFAULT NULL
) ENGINE=InnoDB;
start transaction;
insert into t01(column_of_t01) values(666);
insert into t02(column_of_t02) values(666);
select * from t01;
select * from t02;
rollback;
select * from t01;
select * from t02;

Continue reading MySQL: Transactions in MyISAM and InnoDB