MySQL Bugs: #55278: Easy way to comment lines

Bug #55278	Easy way to comment lines
Submitted:	15 Jul 2010 8:35	Modified:	7 Sep 2011 20:45
Reporter:	Carlos Ollero	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S4 (Feature request)
Version:	5.2.25	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	editor

Description:
Select a bunch of lines and toggle the comments on them.

How to repeat:
Feature request

Many thanks for writing a feature request.

Unfortunately, I am not able to follow you.

What exactly do you mean here?

Hi,

What I mean is, if I have, for example:

select * from A
  where x in (
    select x from B
    where
    y = 3 and
    z = 4 and
    t = 7
  )

And I want to comment out some lines of the query to test, and then put them back, for example, I have to go line by line writing the comments, for example:

select * from A
  where x in (
    select x from B
    where
--     y = 3 and
--     z = 4 and
    t = 7
  )

And then, to uncomment them, re-editing the lines. If I have a whole file to develop it is really boring to go line by line writing the comments marks and erasing them. So if there can be a keyboard shortcut to toggle the comments in the selected lines it could be great, for example, the eclipse Ctrl+/.

Thanks!

Thank you for the feature request.

Fixed as of 5.2.31:

+        <guimenu>Edit</guimenu>, <guimenu>Format</guimenu>,
+        <guimenu>Un/Comment Selection</guimenu> was added.