How can you export the table as an xml file in mysql?

933

---

How can you create and drop view in mysql?

976

---

What is an index? How can an index be declared in mysql?

940

---

What are the differences between a primary key and foreign key?

1167

---

What is the latest version of php and mysql?

1275

---

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

1000

---

How to get last inserted id after insert data from a table in mysql?

1042

---

What is the role of a limit in a mysql query?

1059

---

What are the different mysql database engines?

1242

---

What are aggregate functions in mysql?

1439

---

Explain unique key in sql.

1063

---

How to use distinct and count in sql query? Explain

1088

---

What is the difference between having and a where in sql?

1154

---

Explain the components of sql?

1112

---

Explain normalization and what are the advantages of it?

1005

---