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

As a subquery running the command "DESC <tempoprary table name>"

    XMLWordPrintable

    Details

      Description

      In subqueries SELECT command is supported.
      Although DESC also provides a result set, it cannot be used as a subquery.

      In order to evaluate the columns of a temporary table,
      I need the columns names/types as cursor that
      provided by DESC <table name> command.

      If DESC command can be used as a subquery
      it would be able to applicated to a "for loop" like this:

      for REC in (DESC <table name>) do
      – REC.Field, REC.Type, REC.Null
      . . .
      end for;

      or to a "create temporary table" command like:

      create temporary table Temp1 as
      select * from (DESC <table name>) CC;

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            tegmen Harun Tegmen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration