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

Add documentation about ALTER TABLE .. RENAME COLUMN IF EXISTS

    XMLWordPrintable

Details

    • Notable changes

    Description

      This useful statement works in MariaDB:

      create table t (i int);
      alter table if exists t rename column if exists i to j;
      

      But the IF EXISTS clause isn't documented here:
      https://mariadb.com/kb/en/alter-table/

      The clause is documented for CHANGE COLUMN, but that's a less useful statement, given that the data type must be supplied as well.

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            lukas.eder Lukas Eder
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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