Importing XML Data into MySQL Tables Using a Stored Procedure

(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 S

Read More - Register for Free Membership