I am trying to find an easy way to deploy updated stored procedures to my clients, without accessing the MySQL Workbench and using the Import module.
I have my stored procedures exported to a .sql file with the export module of MySQL Export module.
I am trying to simulate something like reading the content of .sql file and execute it. This is my code, Unfortunately it gives an syntax error.
PREPARE sqlStmt FROM @stmt;
DEALLOCATE PREPARE sqlStmt;
Any input is welcome.