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

mysqldump client: --tab export with column names header row

Details

    Description

      I think 

      --tab

      export would be improved if there was an option to export a row of column headers. This is a very standard CSV format.

      Ex. rather than just the .sql file, you could have an output like:

      "City","State","Zip"
      "New York","New York","10001"
      "Washington","District of Columbia","20002"

      Perhaps 

      --prefix-data-by-column-names

      , which can only be used together with 

      --tab

      , would match the style of other options.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29889 mysqldump --tab --header is slow

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            za3k Zachary Vance created issue -
            za3k Zachary Vance made changes -
            Field Original Value New Value
            Description I think `--tab` export would be improved if there was an option to export a row of column headers. This is a very standard CSV format.

            Ex. rather than just the .sql file, you could have an output like:
            {quote}
            "City","State","Zip"
            "New York","New York","10001"
            "Washington","District of Columbia","20002"
            {/quote}

            Perhaps `--prefix-data-by-column-names`, which can only be used together with `--tab`, would match the style of other options.             		I think `--tab` export would be improved if there was an option to export a row of column headers. This is a very standard CSV format.

            Ex. rather than just the .sql file, you could have an output like:
            {quote}
            "City","State","Zip"
            "New York","New York","10001"
            "Washington","District of Columbia","20002"
            {quote}

            Perhaps `-\-prefix-data-by-column-names`, which can only be used together with `--tab`, would match the style of other options.
            za3k Zachary Vance made changes -
            Description I think `--tab` export would be improved if there was an option to export a row of column headers. This is a very standard CSV format.

            Ex. rather than just the .sql file, you could have an output like:
            {quote}
            "City","State","Zip"
            "New York","New York","10001"
            "Washington","District of Columbia","20002"
            {quote}

            Perhaps `-\-prefix-data-by-column-names`, which can only be used together with `--tab`, would match the style of other options.             		I think `--tab` export would be improved if there was an option to export a row of column headers. This is a very standard CSV format.

            Ex. rather than just the .sql file, you could have an output like:
            {quote}
            "City","State","Zip"
            "New York","New York","10001"
            "Washington","District of Columbia","20002"
            {quote}

            Perhaps {{--prefix-data-by-column-names}}, which can only be used together with {{--tab}}, would match the style of other options.
            za3k Zachary Vance made changes -
            Description I think `--tab` export would be improved if there was an option to export a row of column headers. This is a very standard CSV format.

            Ex. rather than just the .sql file, you could have an output like:
            {quote}
            "City","State","Zip"
            "New York","New York","10001"
            "Washington","District of Columbia","20002"
            {quote}

            Perhaps {{--prefix-data-by-column-names}}, which can only be used together with {{--tab}}, would match the style of other options.             		I think {{{{noformat}--tab{{noformat}}}} export would be improved if there was an option to export a row of column headers. This is a very standard CSV format.

            Ex. rather than just the .sql file, you could have an output like:
            {quote}
            "City","State","Zip"
            "New York","New York","10001"
            "Washington","District of Columbia","20002"
            {quote}

            Perhaps {{{{noformat}}--prefix-data-by-column-names{{noformat}}}}, which can only be used together with {{{{noformat}}--tab{{noformat}}}}, would match the style of other options.
            za3k Zachary Vance made changes -
            Description I think {{{{noformat}--tab{{noformat}}}} export would be improved if there was an option to export a row of column headers. This is a very standard CSV format.

            Ex. rather than just the .sql file, you could have an output like:
            {quote}
            "City","State","Zip"
            "New York","New York","10001"
            "Washington","District of Columbia","20002"
            {quote}

            Perhaps {{{{noformat}}--prefix-data-by-column-names{{noformat}}}}, which can only be used together with {{{{noformat}}--tab{{noformat}}}}, would match the style of other options.             		I think {{{noformat}--tab{noformat}}} export would be improved if there was an option to export a row of column headers. This is a very standard CSV format.

            Ex. rather than just the .sql file, you could have an output like:
            {quote}
            "City","State","Zip"
            "New York","New York","10001"
            "Washington","District of Columbia","20002"
            {quote}

            Perhaps {{{noformat}--prefix-data-by-column-names{noformat}}}, which can only be used together with {{{noformat}--tab{noformat}}}, would match the style of other options.
            serg Sergei Golubchik made changes -
            Labels beginner-friendly
            serg Sergei Golubchik made changes -
            Summary [Feature Request] --tab export with column names header row --tab export with column names header row
            serg Sergei Golubchik made changes -
            Summary --tab export with column names header row mysql client: --tab export with column names header row
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 106919 ] MariaDB v4 [ 131253 ]
            danblack Daniel Black made changes -
            Summary mysql client: --tab export with column names header row mysqldump client: --tab export with column names header row
            danblack Daniel Black made changes -
            Assignee Daniel Black [ danblack ]
            danblack Daniel Black made changes -
            Fix Version/s 10.11.1 [ 28454 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -

            People

              danblack Daniel Black
              za3k Zachary Vance
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.