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

am from coimbatore.am learning php&mysql. what will be the approx salary for me if i get a job in coimbatore.

1548


What is the purpose of a query?

500


How to check a key exist in an array?

571


Does wordpress still use php?

518


What is the use of get and post method in php?

536






Do you have to initialize variables in php?

487


How do I run a php script in windows?

545


What is session expiry?

527


Tell me how to find current date and time?

539


What is difference between print_r and echo in php?

493


What is query string php?

536


What is call by reference in php?

509


What is the meaning of ‘escaping to php’?

614


What type of operation is needed when passing values through a form or an url?

524


What is the difference between apache and tomcat?

524