Change the database engine

To change the database engine, use the "alter table table name engine = engine name" syntax.

alter table table name engine = engine name;

Here is an example of changing the book table to the InnoDB engine.

alter table book engine = InnoDB;

Here is an example of changing the author table to the MyISAM engine.

alter table author engine = MyISAM;

If you want to check the type of database engine, please refer to the following articles.

MariaDB Tutorial