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

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

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

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.

Is this answer helpful?
0 Yes | 0 No

151 views

More Questions for you:

How to convert the strings to numbers in PHP?

How you can remove the new line character from the end of a text line in PHP?

How you can remove white spaces from the beginning and/or the end of a String in PHP?

How you can remove leading and trailing spaces from user input values in PHP?

How to get number of characters in a String?

How you find a substring from a given string in PHP?

Which is the best way to test the strpos() Return Value in PHP?

How you take a substring from a given string in PHP?

What does special set of tags do in PHP?

How to repair MySQL table?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

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

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

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

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: