Importing XML Data into MySQL Tables Using a Stored Procedure This is an off-site link.  Please review our Terms of Service for additional information.

(Rob Gravelle) In theory, it would seem that a stored procedure would be the perfect vehicle for importing XML data from a file. In practice, there are several mitigating factors to doing so. For starters, the LOAD XML INFILE and LOAD DATA INFILE statements have not been permitted to run within a Stored Procedure since MySQL v5.0.7.

Read this article...

comments powered by Disqus