Explain different types of tables in MySQL?

Posted by Andre Scott | Updated on

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