What are the different table present in MYsql?

Answers were Sorted based on User's Feedback

What are the different table present in MYsql?..

Answer / subrat

MyISAM: This is default. Based on Indexed Sequntial Access
Method. The above SQL will create a MyISA table.
ISAM : same
HEAP : Fast data access, but will loose data if there is a
crash. Cannot have BLOB, TEXT & AUTO INCRIMENT fields
BDB : Supports Transactions using COMMIT & ROLLBACK. Slower
that others.
InoDB : same as BDB

Is This Answer Correct ?    13 Yes 1 No

What are the different table present in MYsql?..

Answer / sankar

its not inoDB is InnoDB

Is This Answer Correct ?    9 Yes 1 No

What are the different table present in MYsql?..

Answer / rajesh kumar

BDB supports transaction and page level locking. InnoDB
Supports Foreign Keys, Row level locking & transaction .

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More MySQL Interview Questions

how many ways we can get the current date in mysql?

2 Answers  

please give me the answer for this: query which generates the second highest integer in the table?

8 Answers  

1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

0 Answers  

Explain MySQL locks?

1 Answers  

What is the difference between a Table and a View?

3 Answers  

How can you move the master database

0 Answers   IBM,

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

5 Answers   Amdocs, MediaSoft,

What are the other commands to know the structure of table using MySQL commands except explain command?

2 Answers   SigmaTree,

Explain advantages of MyISAM over InnoDB?

1 Answers  

How many services is running in sql server?

3 Answers   V2 Solutions, ACC,

explain GROUPBY & HAVING clause with examples.

0 Answers  

How do you start MySQL on Linux?

5 Answers   Cybernet,