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


Please Help Members By Posting Answers For Below Questions

How can we set and destroy the cookie in php?

738


Is it easy to learn php?

735


List few sensible functions in PHP?

780


Is overloading possible in php?

736


What are the functions for imap?

819


What is inheritance in php with example?

773


How to do single and multi line comment in php?

767


Explain what is memcache?

734


Do you know how to declare an array in php?

749


What is $_ get?

757


What is composer json?

696


What is php and why we use it?

717


Is php an oop?

754


What is json php?

780


What is polymorphism in oop php?

761