Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a requirement where i need to load xml file into a mysql table using trigger.

I have written the following trigger to achieve this.

CREATE TRIGGER asdb.payment_test AFTER INSERT ON asdb.abc1
FOR EACH ROW
BEGIN
    load XML local infile 'D:\\New Folder\\form.xml' into table asdb.abc rows identified by '<ApplicantName>';
END;
|
DELIMITER ;

Its giving the following error:

LOAD XML is not allowed in stored procedures

I have googled this to find a solution. I have found that load xml is not allowed in stored procedure since mysql version 5.0.7 (http://stackoverflow.com/questions/16288700/load-xml-via-mysql-stored-procedure)

We are using mysql version 5.5. Is there any possible way to achieve this?

Thanks

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.