Parsing XML from a stored procedure

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Hi there,
I would like to know if I can pass XML data to a MYSQL stored procedure
and then process the XML file to insert its values into a table.
Something like the "SELECT ... FROM OPENXML " from TSQL

Thank you

Re: Parsing XML from a stored procedure

Horacio Escalada wrote:
Quoted text here. Click to load it

No, there is no such feature.  It is a nontrivial problem to map XML
elements into a relational database schema.

Here's an article on using a product called PremiumSoft Navicat to
import XML data into MySQL:

Here's an article about using Perl to load XML data into MySQL:

Bill K.

Re: Parsing XML from a stored procedure

Hi Bill , thank you for your reply. I will then take a different
approach on this issue.

Site Timeline