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.

How to shutdown mysql server?

1016

---

What is the default port of mysql server?

986

---

How do I drop a database in mysql?

1076

---

How to create table with same structure of student table in mysql?

911

---

What is session variable in mysql?

922

---

What is difference between mysql_connect and mysql_pconnect?

986

---

How many ways to get the current time?

926

---

How can an index be declared in mysql?

892

---

List some comparisons operators used in mysql?

944

---

Can't connect mysql server on localhost?

1018

---

How to escape special characters in sql statements?

933

---

What is mysql good for?

845

---

What is delimiter in mysql trigger?

908

---

List some mysql advantages and disadvantages?

917

---

Which command is used to view the content of the table in mysql?

871

---