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,






Categories