Transactions/Rollbacks.

[Tyler Durden]

I'm trying to follow a tutorial on how to use transactions but they always seem to be permanent. Here's what I've done:
start transaction;
select * from accounts;
update accounts
set balance = (balance + 100)
where id = 3;
select * from accounts;
rollback;
select * from accounts;

Nothing gets rolled back though. When I do show table status; it shows accounts as a MyISAM table. I try doing alter table accounts ENGINE = InnoDB; but it still stays as MyISAM