How to change a value of a field using MySQL Workbench?
I have installed MySQL Workbench and I have the following problem.
I perform this simple select query:
SELECT * FROM spring_security.user;
that returns a list of rows.
So, in the output area, I select a field of a specific row and I try to change its value. But I can't do it.
Seems that is is impossible insert a new value for a specific field of a specific row.
Why? How can I use this tool to change a value?
Answer
You can do easy with MySql Workbench this way :
in menu database simply connect
then select the database you need and then the table.
Positioning the mouse over the table name in table schemas explore and so you can see on the rightside a table icon.
Selecting/clicking this icon you can see the date in tabular form (like Toad).
With this tabular form you can edit and apply the change
Applying the change MySq Wworkbench show you the sql code and ask for confirm