Answer / Jitender Kumar

To return query output in XML format, you can use the EXTRACTXML function in MySQL. Here's an example:n```sqlnSELECT EXTRACTXML(XML_DOCUMENT, '/root/element') AS my_element FROM ( SELECT @xml_doc := CONCAT( '<?xml version="1.0"?>n', XML_PRETTY_PRINT( SELECT * FROM table_name ) ) AS XML_DOCUMENT FROM dual ) AS temp;n```

Can not connect to mysql server 10060?

1 Answers  

---

what is the main difference between myisam and innodb

2 Answers   Wipro,

---

Can mysql scale horizontally?

1 Answers  

---

What is the full meaning of mysql?

1 Answers  

---

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

1 Answers  

---

How do I make an action query?

1 Answers  

---

How to change the database engine in mysql?

1 Answers  

---

What is mysqli_connect_error ()?

1 Answers  

---

How are mysql timestamps seen to a user?

1 Answers  

---

Where’s database data actually stored?

1 Answers  

---

How do I uninstall mysql connector?

1 Answers  

---

What is orm in mysql?

1 Answers  

---