What are the different types of tables in MySQL?

Total 5 types of tables are present in mysql as per following.

  • MyISAM
  • Heap
  • Merge
  • InnoDB
  • ISAM

MyISAM is the default storage engine as of MySQL .

What is ISAM?

ISAMĀ  is abbreviated as Indexed Sequential Access Method.It was developed by IBM to store and retrieve data on secondary storage systems like tapes.