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  






Categories