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 the purpose of using a heap table?

1110

---

Can we save images in mysql database?

886

---

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

949

---

How to show table structure mysql?

1004

---

How to dump a table to a file with 'mysqldump'?

1023

---

What is offset limit?

954

---

What is mysql server?

1072

---

Can we join 3 tables in mysql?

942

---

How much does mysql enterprise cost?

919

---

How do I start and stop mysql on windows?

1004

---

How to set the time zone for MySQL to particular country time?

3195

---

How do I exit mysql?

908

---

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

1062

---

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1116

---

How do I connect to a database in mysql workbench?

1017

---