Question

If you want to use MyISAM instead of InnoDB, which option do you need to specify in the CREATE TABLE statement?

a) ENGINE=MyISAM
b) TYPE=MyISAM
c) STORAGE=MyISAM
d) FORMAT=MyISAM

Answer 1

The correct syntax to use MyISAM as the storage engine in a MySQL CREATE TABLE statement is a) ENGINE=MyISAM.

Step-by-step explanation:

If you wish to use MyISAM instead of InnoDB for your MySQL database table, you need to specify the storage engine in the CREATE TABLE statement. The correct option to use is a) ENGINE=MyISAM. The other options provided are incorrect syntax for specifying the storage engine in MySQL. The TYPE option was deprecated in earlier versions of MySQL and is no longer supported in current versions. STORAGE and FORMAT options do not exist for the purpose of defining the storage engine in MySQL.