How will you export tables as an xml file in mysql?

0 Answers  

---

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

0 Answers  

---

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

0 Answers  

---

What is mysql default port number?

0 Answers  

---

How to create and drop view in mysql?

0 Answers  

---

What are the functions in mysql?

0 Answers  

---

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

2 Answers  

---

How do I change global variables in mysql?

0 Answers  

---

What is the difference between a heap table and temporary table?

0 Answers  

---

How many rows can mysql hold?

0 Answers  

---

I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks

2 Answers   Sun Life,

---

How can you do the fine tunning?

3 Answers   ACC,

---