I need to convert my existing table from one type to another. Can you explain, how to convert a table from one type to another in MySQL?
Answer No: 161
MySQL provides ALTER TABLE statement to alter the table structure. To convert a table from one type to another, you can use this statement. Take one of the following two examples, both do the same. However, TYPE option is deprecated now:
ALTER TABLE table_name ENGINE = MYISAM;
ALTER TABLE table_name TYPE = MRG_MYISAM;