Re: Input data thru Workbench

[Mike Lischke]

Hey Alex,

yes, inserting data manually is possible. What you need to do is to open a socalled resultset by running a query that returns records. In order to be able to edit that data (or add/remove records) this query must use a single table only, no union etc that makes addressing an individual record impossible, and there must be a primary key.

The grid with the data is displayed in the area below the query editor where you can freely edit any cell etc. Press Apply to send the changes back.

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/