Home »

What are the different tables present in MySQL? Which type of table is generated when we are creating a table in the following syntax: create table employee(eno int(2),ename varchar(10))?

Question List › Category: PHP › What are the different tables present in MySQL? Which type of table is generated when we are creating a table in the following syntax: create table employee(eno int(2),ename varchar(10))?
0 Vote Up Vote Down
jeanderson295 author asked 8 years ago
1 Answers
0 Vote Up Vote Down
shah_kajal184 author answered 8 years ago

Total 5 types of tables we can create1. MyISAM
2. Heap
3. Merge
4. INNO DB
5. ISAM
MyISAM is the default storage engine as of MySQL 3.23. When you fire the above create query MySQL will create a MyISAM table.

Please login or Register to Submit Answer