I have one database(MySQL) where data type of one column is XML. Like the table name is 'class_5_student' and two columns is there-
> std_roll_num [INT]
> std_dtl [XML]
for example
| std_roll_num | std_dtl |
| 1 | <std_1> <name>Tom</name> <age>10</age> <roll>1</roll> </std_1> |
| 2 | <std_2> <name>Sam</name> <age>11</age> <roll>2</roll> </std_2> |
| 3 | <std_3> <name>Lisa</name> <age>10</age> <roll>3</roll> </std_3> |
I know how to connect XML datasource and fetch data from XML file. Is it possible to get data from above table and generate report like -
| Name | Roll | Age |
| Tom | 1 | 10 |
| Sam | 2 | 11 |
| Lisa | 3 | 10 |
Every time I connect this DB, I always get XML column as string.
Please help.
0 Answers:
No answers yet
