Answers were Sorted based on User's Feedback
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
InoDB : same as BDB
|Is This Answer Correct ?||13 Yes||1 No|
Answer / sankar
its not inoDB is InnoDB
|Is This Answer Correct ?||9 Yes||1 No|
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|
how to find missing numbers between two order numbers; and dates ?
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 ?
What are the advantages of stored procedures, triggers, indexes?
What is the use of indexing table?
write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database
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.
How can we store binary data in mysql?
What is ACID?
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
what programming language which is used for testing and developement in sql?
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)?
How to find out the second largest element from mysql table