I am working on a private PHP project to teach myself new stuff. One of the things I am learning with the project are MySQL stored procedures. I have a working news module, which does not yet support automatic RSS-Feed generation.
While programming that part, I was wondering if you can execute a PHP file from within a stored procedure. The reasoning is that I would not need to worry about when to update the XML-File, kind of like a TIMESTAMP field with ON UPDATE CURRENT_TIMESTAMP
So, can you execute a script from within a stored procedure?
No you can't do that.
MySQL doesn't know how to handle PHP scripts.