Parsing XML from a stored procedure

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:
> 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

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:
http://www.phpbuilder.com/columns/kenlin20031229.php3

Here's an article about using Perl to load XML data into MySQL:
http://www.kitebird.com/articles/mysql-xml.html#TOC_5

Regards,
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.