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)) ?
Answer Posted / vikash shaw
Total 5 types of tables we can create in mysql
1. 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.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is a string in php?
What is php session id?
How do you count numbers in php?
What is the expansion of LAMP?
Which is correct about mysqli and pdo?
Xplain is it possible to use com component in php?
What does $_server means?
What is var_dump?
How to write a program to make chess?
Which MySQL function would you use to select a database?
How do you check if an arraylist is empty?
What are the encryption functions in php?
What is mvc? Why its been used?
Explain the difference between isset() and empty()?
What is nan value?