Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
Just as CREATE TABLE ... LIKE exists, it would be very useful to have also such SQL expression for procedures:
CREATE [OR REPLACE] PROCEDURE [IF NOT EXISTS] sp_name |
{ LIKE old_stored_procedure_name | (LIKE old_stored_procedure_name ) } |
If in such procedures tables used relative references (Different Databases depending on which is in USE), that would allow to copy procedures from one database to another, and call them in the new database, without having to load the procedures again with a SQL script in the new database.
This would allow to automatize execution at the databases level, without having to re-load the procedures from a second programming language for working in MariaDB.