Explain different types of tables in MySQL?

Find below different types of a table in MySQL.

• InoDB: This type of table is mainly used to enhance and support transaction using COMMIT and ROLLBACK commands.
• HEAP: This type of table is mainly used to process data access in a more faster than the normal speed. But on the downside of it, all data will be lost in case of table deletion.
• BDB: This type of table is also used for transaction support implemented using COMMIT command but its processing speed is much slower than that of InoDB.

If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.

Related Questions & Answers

• How do I query a custom post type with a custom taxonomy?
• Is there a way to dispatch actions between two namespaced vuex modules?
• Area of a leaf inside a square using c program
• How to hide FloatingActionButton in Flutter?
• Why we use extract() in PHP?
• How to resize WordPress image to fixed height and auto width?
• How to pass Taps to widgets below the top widget?
• What is Multipurpose Internet Mail Extensions(MIME)?
• Give an example of custom pipe?
• What is the use of setTimeout
• What are components and give an example?
• How to access Provider providers in Dialogs in Flutter?
• How to handle anchor hash linking in AngularJS?
• How do you trim a string in Javascript
• How to get first day of week in PHP?