Answer Posted / prathiba

1.Transactions:MYISAM doesnt support any database
transactions means if the transactions related to large
amount of data transfer it will not provide because memory
is less. But INNODB will provide transactions.

2.Locking:MYISAM provide the table level locking means if
the data in one table has been modified by the other
table ,the entire table will lock for the next process.But
INNODB provide the row level locking only the row of the
table that is being updated is locked.

3.Foreign keys – MYISAM tables do not support foreign keys.

4.Data Types:MYISAM provide a full variety of datatypes,but
INNODB will not.

What is the use of mysqli_connect in php?

903

---

Why phpmyadmin is used for mysql?

943

---

Explain the different types of constraints?

948

---

what is mysql optimization in brief?

2362

---

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

970

---

What is mysql primary key?

977

---

what is the default port for mysql server? : Mysql dba

1047

---

What are the common mysql functions?

944

---

How can you filter the duplicate data while retrieving records from the table?

899

---

What is the usage of regular expressions in mysql?

902

---

How do I tune a mysql query?

895

---

What is different between sql and mysql?

1020

---

What are the advantages of a procedure?

918

---

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

886

---

How do I find the size of a mysql database?

916

---