Answer Posted / madhuri

1) MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.
2)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.
3)Upto Mysql 5.0 MyIsam is the default engine and from
Mysql 5.1 Innodb is the default engine.
4)MyIsam supports table level lock and where as Innodb
supports row level locking.

Thanks.,
Madhuri.

What is difference between mysql mysqli and pdo?

857

---

How to convert character strings to dates?

1026

---

Can mysql store files?

865

---

What is the purpose of -> in the mysql terminal?

1033

---

What are the steps involved in query processing?

832

---

What is difference between mysql and mysql workbench?

870

---

What is difference between pdo and mysqli?

911

---

In how many ways we can retrieve data in the result set of mysql using php?

1055

---

Can we create table in stored procedure?

899

---

Where is mysql data stored linux?

933

---

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

938

---

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

1949

---

How to enable or disable a row of a table using MySQL in struts?

4032

---

What are date and time intervals?

920

---

Where is mysql password stored?

867

---