%Transaction processing supported for INNODB tables
alter table tableName type = INNODB;

%start transaction
start transaction;

%operate upon the tables

commit; % to make changes permanent

rollback; % to restore database to state before last start transaction