There are basically two types of tablein MYSQL: 1. Transaction safe 2. No

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)) ?

Question Posted / albert

7 Answers
19500 Views
HCL, I also Faced
E-Mail Answers

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

What are arguments in php?

979

How do you measure variables?

1006

How to set a value in session? How to remove data from a session?

948

Whether php supports microsoft sql server?

995

What is the difference between client-side and server-side programming?

1029

What is isset in php?

928

What are php filters?

918

write a note on Testing the web site

1815

How can you create a session in php?

1014

Does exist in php?

946

What is stripslashes php?

931

How to declare an array in php?

1040

What is mysql_fetch_array?

993

What is the default time of cookie in php?

957

Is it easy to learn php?

922