Bug #58557 "Copy Column Names" feature from Query Browser still missing in Workbench
Submitted: 29 Nov 2010 13:08 Modified: 13 Jun 2013 2:09
Reporter: Ralf Neubauer Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.30 CE OS:Windows
Assigned to: CPU Architecture:Any
Tags: regression

[29 Nov 2010 13:08] Ralf Neubauer
Bug #50459 may be solved for the submitter, but not for me. The given advice 'This is already available when you open the context menu for a table in the sidebar or the "Overview".' obviously only works for simple 'select * from mytable' queries (where you could just use 'describe mytable' or so), but obviously fails for queries like:

select * from a join b using(i) join c using(j)


   count(*) as cnt,
   avg(a)+sin(sum(b)) as angle
from a join b using(i)
group by j

or similar. I like using "Copy Column Names" together with "Copy Row Content" to quote some result rows for use in Bug reports or E-Mails without having to use an intermediate CSV file and having to find the rows in this file again; having an option "Copy Row Content with Column names" in the viewer's context menu would be even more useful for that.

Note, I'm not interested in the table's columns but in the result columns. Query Browser lets you copy the result columns to the clipboard, as such the feature is still missing in Workbench. Being able to 'convert' between the two with CREATE TABLE ... AS SELECT ... is not a solution...

How to repeat:
Open SQL Editor and enter:

SELECT now() as test_column

Start query. A result window appears. Try to copy the column's name from the result window. Try to copy&paste the complete result (column names and column data in e.g. CSV format) into a text editor _without_ having to create and delete a temporary file. Try doing this with only some rows.
[29 Nov 2010 17:48] Valeriy Kravchuk
Thank you for the problem report.
[21 Mar 2012 18:14] Dimitriy A
I am also waiting for this feature to be added.

There should be two copy methods:
Copy Content
Copy Content with Header
[13 Jun 2013 2:09] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.0.2 public beta release, and here's the changelog entry:

A "Copy Row (with names)" option was added to the context menu for record

Thank you for the bug report.
[13 Jun 2013 20:22] Philip Olson
Related bug: Oracle Bug #11764870 / MySQL Bug #57748