MySQL Bugs: #58557: "Copy Column Names" feature from Query Browser still missing in Workbench

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:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.30 CE	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	regression

Description:
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)

or

select
   a.*,
   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.

Thank you for the problem report.

I am also waiting for this feature to be added.

There should be two copy methods:
Copy Content
Copy Content with Header

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
sets.

Thank you for the bug report.

Related bug: Oracle Bug #11764870 / MySQL Bug #57748