Question

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

Answer 1

Each MyISAM table is stored on disk in three formats:

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