Answer / manoj

both myisam and innodb are storange enginein sql.
innodb support transaction, foreign key while myisam not
support transaction.

Answer / ranganath

Other differences are :

1. innodb requires more RAM than mysiam
2. myisam relies on OS for caching while innodb caches with
in the engine itself.

3. Most preffered is innodb because

- Transaction safe
-It has commit, rollback, and crash recovery capabailities
- Innodb is designed for maximum performance when processing
large volumes of data.

What is table level locking in mysql?

0 Answers  

---

What does it mean to be case sensitive?

0 Answers  

---

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers  

---

What is the difference between mysql_fetch_array and mysql_fetch_object?

4 Answers   CTS,

---

What is the maximum length of a table name, database name, and fieldname in MySQL?

3 Answers   Accenture, Pioneer, TISL,

---

What is the purpose of -> in the mysql terminal?

0 Answers  

---

What is triggers and how it can be used in mysql?

0 Answers  

---

What are the differences between innodb and myisam engines?

0 Answers  

---

What is the query to display top 20 rows?

0 Answers  

---

why not null is not allowed at table level

0 Answers   Cognizant,

---

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

0 Answers  

---

Is mariadb faster than mysql?

0 Answers  

---