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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How check submit button is clicked in php?

600


What is the use of imagetypes() method?

617


How is csrf token generated?

601


How does php work with apache?

614


Can we use include ("xyz.php") two times in a php page "index.php"?

658






What is php routing?

600


How can I find my php version?

632


Tell me how comfortable are you with writing html entirely by hand?

604


Explain about getters and setters in php?

622


What are php filters?

597


Can a super () and this () keywords be in same constructor?

565


How to close a session properly?

613


Tell me what does the scope of variables means?

608


What is the difference between Session and Cookie?

660


What is the use of Mbstring?

624