assign engine mysql table code example Example: alter table engine mysql ALTER TABLE table_name ENGINE=InnoDB;