Menu
MySQL Workbench allows one edit Select query results which seems a nice feature, yet if I rerun query the changes do not stick. Is there way to edit tables (preferably in query results). I can run update query, yet sometimes editing is more convenient.
349
To edit comments in the specific table, you need to enter into edit mode. Select table, click right mouse button and choose Alter table... option. It will open a new tab in the main pane (right-hand side of the screen) with the editor.
Right click the table shown at the left in Schema tab of workbench and then select Alter Table . You will get a window like this -> Here you can see the column names available, edit here and click on apply.
You need to click "Apply" after you finish editing the data, otherwise it will not save the changes.
169
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
