Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

JSON with No root node - Format from XML output - SQL

Language: Editor: Layout:
View schema
Execution time: 0,02 sec, rows selected: 8, rows affected: 8, absolute service time: 0,17 sec 
edit mode |  history  | discussion
   cid name age volunteer address
1 1001 Jack 25 True test address1
2 1002 Brandy 34 False test address2
3 1003 Vincent 14 False test address3
4 1004 Rado 35 True test address4
   cid xml_data
1 1001 <Final><cid>1001</cid><name>Jack</name><age>25</age><volunteer>1</volunteer><address>test address1</address></Final>
2 1002 <Final><cid>1002</cid><name>Brandy</name><age>34</age><volunteer>0</volunteer><address>test address2</address></Final>
3 1003 <Final><cid>1003</cid><name>Vincent</name><age>14</age><volunteer>0</volunteer><address>test address3</address></Final>
4 1004 <Final><cid>1004</cid><name>Rado</name><age>35</age><volunteer>1</volunteer><address>test address4</address></Final>