Bug #66922 Allow to copy column value from multiple rows
Submitted: 21 Sep 2012 20:33 Modified: 24 Oct 2012 16:23
Reporter: Maciej Klepaczewski Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:5.2.42 OS:Any
Assigned to: CPU Architecture:Any
Tags: copy

[21 Sep 2012 20:33] Maciej Klepaczewski 
Description:
It's often necessary to copy values in single column from multiple rows (for example id's of some rows) for further/external processing. Currently when multiple values in single column are selected 'Copy field content' options are grayed out.

How to repeat:
Execute:

SELECT 1,2
UNION
SELECT 2,3
UNION
SELECT 3,4
UNION
SELECT 4,5

and try to copy second column.

Suggested fix:
I propose to allow to copy these values as string where each value is separated with comma (just like GROUP_CONCAT() would do it).
[24 Oct 2012 16:23] Armando Lopez Valencia 
Thanks for your request