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

Answer / sankar

its not inoDB is InnoDB

Answer / rajesh kumar

BDB supports transaction and page level locking. InnoDB
Supports Foreign Keys, Row level locking & transaction .

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

1 Answers  

---

Explain the difference between mysql and mysql interfaces in php?

1 Answers  

---

What is the data source name for mysql?

1 Answers  

---

Do you need a license for mysql?

1 Answers  

---

What is Foreign Key? What is the main difference between primary key and Foreign Key ? How Foreign Key can be defined? Is Foreign key is used to join two or more table?

4 Answers  

---

What are the advantages of MySQL when compared with Oracle?

1 Answers  

---

Is mysql free for commercial use?

1 Answers  

---

How MySQL is different from SQL?

17 Answers   HCL, IBM,

---

How will show all records containing the name "sonia" and the phone number '9876543210'

1 Answers  

---

What are the types of index?

1 Answers  

---

What is federated tables in mysql?

1 Answers  

---

How can we get the number of rows affected by query?

1 Answers  

---