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.

Write a command to view mysql database table structure?

972

---

What is trigger in mysql?

937

---

How many rows we can insert in a mysql table?

969

---

What is the use of i-am-a-dummy flag in mysql?

1017

---

How do I copy a table in mysql?

952

---

How many rows can be inserted in mysql at a time?

1018

---

What is difference between mysql and mysql workbench?

964

---

Explain csv tables.

1023

---

What is delimiter $$?

975

---

How to escape special characters in sql statements?

981

---

What does "i_am_a_dummy flag" do in mysql?

965

---

What is current version of mysql?

983

---

How do I select a database in mysql?

1077

---

Is there a way to see the files which are stored?

976

---

What does mysql_fetch_assoc do?

968

---