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

Can I write php code in html file?

935

What does type casting mean in php? Explain with an example?

919

What is a namespace in php?

905

Do you know what are traits?

956

Where do we use get and post?

927

Does php need apache?

872

how to detect a mobile device using php

1030

how to track no of users logged in?

969

What is array function in javascript?

951

Tell me what are sql injections, how do you prevent them and what are the best practices?

864

What are php expressions?

1029

Can I learn php without knowing c?

956

What is the use of trim function in php?

919

Do you know how to declare an array in php?

929

What is html used for?

954