How to create MyISAM / InnoDB table in MySQL

We all know how to create a table in MySQL. But have you ever given the Type of MySQL Engine while creating a Table?.

All we do is, write a CREATE TABLE statement to create a table, but it always takes the default engine, most of the time it would be MyISAM, some newer versions of MySQL having InnoDB as default engine.

Anyhow you can tell the MySQL to create the specific engine type while creating a table, see the demo query below:

All you have to do is give the ENGINE name after the query,





Related Posts

Leave a Reply