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

Which function would you use to insert a record into a database in php?

568


What is difference between print and echo in php?

479


Tell us how can we display the output directly to the browser?

589


What does the unlink() function mean?

581


Is php strongly typed?

621






What is the use of mvc in php?

525


What is the default time of cookie in php?

541


How to take a substring from a given string in php?

522


What is the method to execute a php script from the command line?

561


What function should you use to join array elements with a glue string?

556


How do you pass a variable by value?

586


What are the difference between abstract class and interface in oops?

516


What is a persistence cookie?

527


What is cookies? How to create cookies in php?

527


Tell me what is the use of the function htmlentities?

525