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 dbms in mysql?

1012

---

What is the maximum size of mysql database?

992

---

What is key in mysql?

950

---

What is the usage of ENUMs in MySQL?

1179

---

What is difference between oracle and mysql?

988

---

How to insert dynamic values in mysql using php?

1184

---

Explain about reporting services of MYSQL?

1123

---

What is the phantom problem?

1043

---

What are the difference between now and current_date in mysql?

1525

---

How to use mysqldump to create a copy of the database?

1132

---

What is a csv table?

1047

---

Why MySQL is used?

1075

---

Can we write procedure in mysql?

985

---

How do you create a table in mysql workbench?

975

---

What are the non-standard sql commands supported by 'mysql'?

1047

---