MySQL Forums
Forum List  »  MySQL Workbench

Re: Where did 'edit table data' go?
Posted by: Mike Lischke
Date: August 23, 2013 01:45AM

Izak,

in earlier versions of WB we needed help by the user to tell if a result set was editable or not. Hence we introduced an own keyword (EDIT). In the context menu for a table we added the "Edit Table Data" entry to make it a little easier for the user (this command added the EDIT keyword automatically).

Now, with our enhanced parsing, the EDIT keyword is no longer necessary and we removed support for it. Consequently, no separate "Edit Table Data" entry is needed anymore. Just do a SELECT ... and if the conditions for editable result sets are met it will automatically be made editable (conditions are for example: a primary key must exist, no functions or constant values are used, no union and no joins either).

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Where did 'edit table data' go?
673
August 23, 2013 01:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.