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.

Ramu Prasad

Published on 21-Feb-2018 06:39:23

• Related Questions & Answers
• How can I change the storage engine of a MySQL table?
• How to update MySQL table storage engine
• How to convert MyISAM to InnoDB storage engine in MySQL?
• How to display all tables in MySQL with InnoDB storage engine?
• How to display the storage engine while implementing JDBC - MySQL CONNECTION query?
• How can we find out the storage engine used for a particular table in MySQL?
• How to create a MySQL table with InnoDB engine table?
• How to display all the tables in MySQL with a storage engine?
• How do I know if a MySQL table is using myISAM or InnoDB Engine?
• MySQL - changing table engine from innoDB to MyISAM?
• How to display the Engine of a MySQL table?
• How to know which storage engine is used in MongoDB?
• How to alter the database engine of a MySQL database table?
• How to change Table Engine in MySQL?
• How to create a MySQL table with MyISAM engine table?