When creating a MySQL table, how do I specify the storage engine of my choice instead of using the default storage engine InnoDB?

When creating a MySQL table, you can specify the storage engine as follows -

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

ENGINE keyword specifies the storage engine to be used for this specific table.

The above is the detailed content of When creating a MySQL table, how do I specify the storage engine of my choice instead of using the default storage engine InnoDB?. For more information, please follow other related articles on the PHP Chinese website!