1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

What are the different table present in MYsql?

Question Posted / subrat

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

Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

1 Answers  

How many rows can a mysql table hold?

0 Answers  

How do I copy a table in mysql?

0 Answers  

Why to use char instead of varchar in the database?

0 Answers  

Can we store images in mysql database?

0 Answers  




How can I compare two mysql databases?

0 Answers  

What is the default port of mysql server?

0 Answers  

Is mysql a scripting language?

0 Answers  

What does tee command do in MySQL?

1 Answers  

How to delete a database from mysql server.

0 Answers  

How many columns can you create for an index?

0 Answers  

using primary can we relate two table, with out foreign key?

0 Answers  

For more MySQL Interview Questions Click Here
Categories