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 explode () and split () functions in php?

615


Can age be a variable?

521


Tell me what is pear?

553


Why did you choose this particular career path?

8354


What is member function?

568






Why echo is faster than print in php?

522


What does nan stand for computer science?

504


what is mean by portal

1466


What are php functions?

554


What is difference between md5 and SHA256?

541


What are php applications?

514


Is empty function c++?

520


Explain some of the php array functions?

582


Which function would you use to merge two arrays in php?

575


What is difference between rest api and restful api?

487