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

What is the difference between javascript and php?

747


What is htaccess? Why do we use this and where?

718


What is array filter in php?

749


Php says that an array is an ordered map. But how the values are ordered in an array?

818


What is smarty?

724


Explain me is it possible to destroy a cookie?

750


Why do we use query?

699


What are the uses of explode() and implode() functions?

757


What is session_start () in php?

722


How to remove all duplicate values in array in php?

740


What is the difference between for and foreach loop in php?

843


What is the difference between == and === operator in PHP?

667


When viewing an html page in a browser, the browser often keeps this page in its cache. What can be possible advantages/disadvantages of page caching? How can you prevent caching of a certain page (please give several alternate solutions)?

753


What is the difference between for and foreach in php?

699


Does cors prevent csrf?

706