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

Answers were Sorted based on User's Feedback



What are the different tables present in mysql, which type of table is generated when we are creati..

Answer / umesh ms analytica-india

Default type is MyISAM

Generates 3 files

1.frm
2.Myd
3.Myi

format files

Is This Answer Correct ?    24 Yes 5 No

What are the different tables present in mysql, which type of table is generated when we are creati..

Answer / sunil kumar

There are fives tables in MySQL
1 MyISAM
2 Heap
3 Merge
4 INNODB
5 ISAM


When we create a table in MySQL, MyISAM is created

Is This Answer Correct ?    11 Yes 3 No

What are the different tables present in mysql, which type of table is generated when we are creati..

Answer / tariq

There are basically two types of tablein MYSQL:
1. Transaction safe
2. Non transaction safe

Transaction safe consist of InnoDB, BDB
Non transaction table includes ISAM, MYISAM, MERGE, HEAP

Is This Answer Correct ?    7 Yes 3 No

What are the different tables present in mysql, which type of table is generated when we are creati..

Answer / 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

What are the different tables present in mysql, which type of table is generated when we are creati..

Answer / albert

There are basically two types of tablein MYSQL:
1. Transaction safe
2. Non transaction safe
/**
*Transaction safe consist of InnoDB, BDB
*Non transaction table includes ISAM, MYISAM, MERGE, HEAP
*/
Default type is MyISAM

Is This Answer Correct ?    3 Yes 1 No

What are the different tables present in mysql, which type of table is generated when we are creati..

Answer / mani

5 type of table is there

1.MyISAM
2.Heap
3.Merge
4.InnoDB
5.BDB

Is This Answer Correct ?    2 Yes 0 No

What are the different tables present in mysql, which type of table is generated when we are creati..

Answer / sailesh jaiswal (lamp institut

MySQL supports 2 types of tables.
1. Transaction Safe Table (TST)
2. Non-Transaction Safe Table (NTST)

1. Transaction Safe Table: This type is safer compared to
NTST. Here transactions are temporary. We have ROLLBACK &
COMMIT commands available. Supports Foreign Key, Locking.
Used for More WRITES & Less READS.
Storage engines INNODB, BDB creates TSTs

2. NTST: Here transactions are permanent. No COMMIT, No
ROLLBACK. Partial Support for Foreign Key, Locking. Used for
More READS & Less WRITE.
Storage engines MyISAM, HEAP creates NTSTs.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More PHP Interview Questions

How check field is empty or not in php?

0 Answers  


Do you know what is use of count() function in php?

0 Answers  


What is list function with their uses.

0 Answers  


What are the advantages of PHP over HTML?

11 Answers   Infosys, Torque Infotech,


In php how can you jump in to and out of "php mode"?

0 Answers  






How can we convert the time zones using PHP?

1 Answers  


Is php used for frontend or backend?

0 Answers  


What is php limit?

0 Answers  


Why do we use namespace in php?

0 Answers  


Explain type casting and type juggling.

0 Answers  


How to declare an array in php?

0 Answers  


How can we display the output directly to the browser?

0 Answers  


Categories