Re: Update a view in Workbench

[Mike Lischke]

Hi Tom,

views are usually created to hide some more complex handling behind a simple relationship. However, this makes them more often than read-only. Since MySQL Workbench is not the MySQL server, it has not all the information at hand that would be needed to decide whether a view is "editable" (meaning it can be used to update values). Hence you are limited to tables with a PK, no union or subselect or aggregate or other such things.

If you like you can open a feature request in our bug database to have the detection improved that decides whether a resultset is editable or not.

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/