What Are The Different Tables Present In Mysql, Which Type Of Table I

1.	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» Total 5 types of tables we can create MyISAM Heap MERGE INNO DB ISAM MyISAM is the DEFAULT storage ENGINE as of MYSQL 3.23 and as a result if we do not specify the table name EXPLICITLY it will be assigned to the default engine. Total 5 types of tables we can create MyISAM is the default storage engine as of MySQL 3.23 and as a result if we do not specify the table name explicitly it will be assigned to the default engine.

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»

Total 5 types of tables we can create

MyISAM
Heap
MERGE
INNO DB
ISAM

MyISAM is the DEFAULT storage ENGINE as of MYSQL 3.23 and as a result if we do not specify the table name EXPLICITLY it will be assigned to the default engine.

Total 5 types of tables we can create

MyISAM is the default storage engine as of MySQL 3.23 and as a result if we do not specify the table name explicitly it will be assigned to the default engine.

Discussion

No Comment Found

Related InterviewSolutions

How To Turn On The Session Support?
What Is The Difference Between Reply-to And Return-path In The Headers Of A Mail Function?
Please Give A Regular Expression (preferably Perl/preg Style), Which Can Be Used To Identify The Url From Within A Html Link Tag.
When You Want To Show Some Part Of A Text Displayed On An Html Page In Red Font Color? What Different Possibilities Are There To Do This? What Are The Advantages /disadvantages Of These Methods?
Tools Used For Drawing Er Diagrams.
How To Reset/destroy A Cookie?
How Can I Retrieve Values From One Database Server And Store Them In Other Database Server Using Php?
If We Login More Than One Browser Windows At The Same Time With Same User And After That We Close One Window, Then Is The Session Is Exist To Other Windows Or Not? And If Yes Then Why? If No Then Why?
What Are The Other Commands To Know The Structure Of A Table Using Mysql Commands Except Explain Command?
What Is The Maximum Length Of A Table Name, A Database Name, Or A Field Name In Mysql?

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)) ?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment