Sunday, August 26, 2012

MySQL: Change table type, set InnoDB or MyISAM

To modify the storage engine of a MySQL table, one can use one of the following.

ALTER TABLE `table_name` ENGINE = InnoDB;

OR

ALTER TABLE `table_name` ENGINE = MYISAM;

No comments: