MySQL Forums
Forum List  »  Connector/Node.js

Using JavaScript with a database
Posted by: توكيل صيانة ايديال زانوسي
Date: November 23, 2017 04:04AM

Hi,

I am using MySQL 5.6 for loading XML file into database table. I found "LOAD XML" is very useful for this purpose. However, I am facing a problem in loading data of child tag. Below is sample XML file.

<companies>
<company id=1 name=test>
<titleArts>
<image url="http://img-origin.abc.com/bed5.jpg";; creditLine="" selected="true"/>
</titleArts>
<widePosters>
<image url="http://img-origin.abc.com/6ac6c0.jpg";; creditLine="" selected="true"/>
</widePosters>
<posters>
<image url="http://img-origin.abc.com/1.jpg";; creditLine="" selected="true"/>
<image url="http://img-origin.abc.com/2.jpg";; creditLine="" selected="false"/>
</posters>
</company>
</companies>

As you can see titlearts, wideposters, posters have image tag. If i use load xml and specify <image> tag, It will load all 4 records. But i want to load only data from posters tag. If i use tag <posters>, It is only loading last record. But i want to load both 2 image url's with in posters tag. How can i do this? Appreciate your help on this.

Thanks
Ravi

Options: ReplyQuote


Subject
Written By
Posted
Using JavaScript with a database
November 23, 2017 04:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.