Answer / satya

MyIsam is my default storage engine , where as InnoDB is
faster storage Engine and offers row level locking ,

Answer / 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 new mysqli?

0 Answers  

---

What are stored procedures and functions?

0 Answers  

---

Are stored procedures precompiled?

0 Answers  

---

Write a query to select all teams that won either 1, 3, 5 or 7 games.

0 Answers  

---

What is identity in mysql?

0 Answers  

---

---

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

0 Answers  

---

What is difference b/w composit key n primary key and forigion key?

4 Answers  

---

I have two sql database at different PC.how can link b/w database and database tables.

2 Answers  

---

How do I start mysql server?

0 Answers  

---

Explain % and _ inside like statement?

0 Answers  

---

How can you find out the version of the installed mysql?

1 Answers  

---

what is the advantage of left outer join?

2 Answers  

---