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 to find missing numbers between two order numbers; and dates ?

1 Answers  


I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers  


What are the advantages of stored procedures, triggers, indexes?

5 Answers  


What is the use of indexing table?

2 Answers  


write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database

3 Answers   Infosys, Webyog,






For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.

1 Answers  


How can we store binary data in mysql?

2 Answers   HP,


What is ACID?

2 Answers  


at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  


what programming language which is used for testing and developement in sql?

3 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  


How to find out the second largest element from mysql table

15 Answers  






Categories