Bug #70029 MySQL WorkBench SELECT * FROM but do not execute

• Submitted: 14 Aug 2013 8:41
• Modified: 6 Apr 2014 18:18
• Reporter: IGG t
• Status: No Feedback
• Category: MySQL Workbench: SQL Editor
• Severity: S4 (Feature request)
• Version: 6.0
• OS: Windows
• CPU Architecture: Any

[14 Aug 2013 8:41] IGG t

Description:
Would it be possible to have an option that can be selected in preferences to either automatically execute queries, or to not automatically execute queries. 

So that when I 'Right Click' on a table > 'Select Rows' it will display the query 'SELECT * FROM tableName;' but doesn't automatically execute.

Quite often I may be working on a basic query of which this forms the basis, but don't want to execute the query straight away. 

Setting it to a limit of 1000 means it always retrieves 1000 rows, every time I start a query. Setting it to a lower limit causes problems if I need to return a higher number of rows.

How to repeat:
Set Preferences to SQL QUERIES > QUERY RESULTS > LIMIT ROWS > UNTICK

Right click on a table 'SELECT ROWS'

A query of type 'SELECT * FROM tablename;' is displayed and executed.

Suggested fix:
Add an option to preferences to 'Do Not automatically execute queries'

[6 Mar 2014 18:17] Alfredo Kojima

If you use right click on table -> Send to SQL Editor -> Select All Statement, it should do what you want

[7 Apr 2014 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".