MySQL Bugs: #50705: No "Edit Table" option in SQL Editor interface

Bug #50705	No "Edit Table" option in SQL Editor interface
Submitted:	29 Jan 2010 0:54	Modified:	2 Feb 2010 15:25
Reporter:	Steve Miller	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.15	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	editor, query, SQL, table

Description:
When looking at a result set in the SQL Editor window, there does not appear to be an option to edit the data via the GUI like in MySQL Query Browser.  This was an extremely useful bit of functionality, and it would be nice to have it back (and if it's still there, it would be nice to have it back in its original place).

How to repeat:
Query a table in your database to get a result set.  There is no "Edit" button on the bottom right of the Result view.

Suggested fix:
Reinstate this bit of functionality to the SQL Editor (or replace the button if the functionality still exists)

We chose this for WB over the solution in QB because for a recordset to be editable, it needs to contain the PK columns. if thats not the case, updates can not be applied to the db. In QB we had some tricky query manipulation that added the PK columns invisibly to the query - but that raised a couple of other complications, so we didn't want to keep that solution in WB.

The artificial EDIT statement can also be used in combination with an WHERE clause, so one can filter the data for editing. We will add a comment to the generated edit code to visualize  this functionality.

comments have been added to the EDIT statement.
will be included in 5.2.16

An entry has been added to the 5.2.16 changelog:

In the SQL Editor a comment has been added to the EDIT statement to clarify its functionality.