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

MySQLMySQLi Database

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.

raja
Updated on 20-Jun-2020 13:47:45

Advertisements