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

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

5 Answers   Amdocs, MediaSoft,

Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr

1 Answers  

What is the difference between mysql and sql?

0 Answers  

What are the steps required to view your mysql database?

0 Answers  

Which mysql function is used to concatenate string?

0 Answers  

How many values can the SET function of MySQL take?

2 Answers   Creative Informatics,

What is difference between group by and order by clause?

0 Answers  

How to enter Characters as HEX Numbers?

0 Answers  

Which statement is used to delete a table in MySQL.

0 Answers  

how many fields can be updated using set in a mysql query?

1 Answers  

What are the advantages of myisam over innodb?

0 Answers  

if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 Answers