Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15003

Innovation: CREATE PROCEDURE ... LIKE

    XMLWordPrintable

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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Juan Juan Telleria
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.