We are planning for a database migration from MS SQL Server to MySQL. Most of our procedures in SQL Server are working with XML data, but we are issues where trying to convert these procedures to MySQL.
Below is the sample XML file. We are sending XML data (not the XML file) directly as a input to the procedure.
With the XML we want the data in the following tabular format in MySQL
Date | Attendance | Personal_Id
Attendance | Personal_Id
Can any experts help us to do this in MySQL.
I tried with ExtractValue but with no help. May be I am not using it properly.
Versions of MySQL we tried for the above: 5.1 & 5.5
Thanks in Advance.