While creating a MySQL table, how can I specify the storage engine of my choice rather than using the default storage engine InnoDB?

While creating a MySQL table, the storage engine can be specified as follows −

mysql> CREATE TABLE Student(id INTEGER PRIMARY KEY, Name VARCHAR(15))
-> ENGINE = 'MyISAM';
Query OK, 0 rows affected (0.28 sec)

The ENGINE keyword specifies the storage engine used for this particular table.

Published on 21-Feb-2018 11:09:23