We are trying to get all the data from mysql table as an xml (Or) Consider we have a table says employees which has an approx of 2000 employee details in it and you are developing a mobile application to show the list in that which would use XML parsing to get data from server.

So, what a server side developer would do to get all of them as an XML ?

Conventionally any programmer will use a for or while loop to get this done and renders the XML data layout the response buffer. i.e., as in following steps

  1. select * from employees is executed to get all data.
  2. start the XML header
  3. A loop is executed all over 2000 records and render each record as an xml node.
  4. end the XML .

This becomes a big burden for the server or processor To serve such purpose MySQL provides u a fine method combination concat and group_concat

SET @xml:=''; SELECT @xml:=concat(@builtxml,"",emp.number,"",emp.name,"") "XML" FROM employees emp,(SELECT @builtxml:='') a ORDER BY @builtxml DESC LIMIT 0,1