- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 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?
Advertisements