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 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. Total 5 types of tables we can create 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.

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
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.

Total 5 types of tables we can create
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.

Discussion

No Comment Found

Related InterviewSolutions

What Is File Upload?
What Is A Result Set Object?
How To Get The Number Of Rows Selected Or Affected By A Sql Statement?
How To Run A Sql Statement?
How To Connect To Mysql From A Php Script?
What Do You Need To Connect Php To Mysql?
What Is Session_register()?
How To Close A Session Properly?
How To Remove Values Saved In The Current Session?
How To Set Session.gc_divisor Properly?

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