Where MyISAM table will be stored and also give their formats of storage?

Each MyISAM table is stored on disk in following formats:

  • The .frm file stores the table definition
  • The data file has a .MYD (MYData) extension
  • The index file has a .MYI (MYIndex) extension