MySQL Forums
Forum List  »  Connector/Node.js

To get XML from url and insert sorted into table.
Posted by: Fredrik Svensson
Date: March 02, 2010 05:29AM


Im new to MySQL and have some problems. Im trying to make a Stored Procedure I will start to describe the scenario:

1. I want to get the xml via a http link, it returns s xml page.
2. Store the XML i a either, a) temporary table b) a variable c) a fil
3. Extract and insert structured (well as structured as could be).

I have access to a betting company’s database (via XML) and they deliver via a http that returns a XML. This XML contains the description of for example 13 matches in football. Ex teams, odds, number of the game, league and so on.

Example XML:
- <match>
<matchstart>2010-03-06 18:20:00</matchstart>
- <match>

This is what should generate a insert row (plus which round, which i stated once in the top of the file).

Is there any one that could help?

Thanx in advance

// Fredrik Svensson

Options: ReplyQuote

Written By
To get XML from url and insert sorted into table.
March 02, 2010 05:29AM

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.