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
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.
What is InnoDB?
lnnoDB is a transaction safe storage engine developed by Innobase Oy which is a Oracle Corporation now.
How MySQL Optimizes DISTINCT?
DISTINCT is converted to a GROUP BY on all columns and it will be combined with ORDER BY clause.
How to enter Characters as HEX Numbers?
If you want to enter characters as HEX numbers, you can enter HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (Ox).
A HEX number string will be automatically converted into a character string, if the expression context is a string.
How to display top 40 rows?
In MySql, top 40 rows are displayed by using this following query:
SELECT * FROM
LIMIT 0,50