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.

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

0 Answers  

---

SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,

---

Can you tell few best practices to be followed for optimization in sql?

0 Answers  

---

What are the mysql database files stored in system ?

0 Answers  

---

how to repair a table in mysql?

2 Answers  

---

How do I edit a table in mysql?

0 Answers  

---

Give the syntax of Grant and Revoke commands?

1 Answers  

---

How do I change global variables in mysql?

0 Answers  

---

In mysql, what is the default storage engine?

0 Answers  

---

How to create a test table in your mysql server?

0 Answers  

---

how to add a new column to an existing table?

0 Answers   MCN Solutions,

---

Explain Normalization concept?

2 Answers   Inuva,

---