My Person table's id, outsourcedData column contain below xml as an String :
<person>
<educations total="2">
<education>
<school-name>Delhi University</school-name>
<degree>Master of Science (MSc)</degree>
<field-of-study>Banking and Financial Support Services</field-of-study>
<start-date>
<year>2009</year>
</start-date>
<end-date>
<year>2013</year>
</end-date>
</education>
<education>
<school-name>American University</school-name>
<degree>Bachelor of Arts (BA)</degree>
<field-of-study>Business Administration and Management, General</field-of-study>
</education>
</educations>
</person>
Is there is any way so I can load this field data parse and insert into education table.
There are lots of row I am having in my database. But now I want to import this data into Education table which is having corresponding fields with xml.(SchoolName,degree......).
In Mysql Database what is the best way to migrate this database.
I am stuck in this place . Please help. help :(
No comments:
Post a Comment