Multirow update in data viewer
In the data viewer, I can update a single row, however, I often want to update all returned rows. It would be nice to right click on the column and set all rows to the same thing. As is, I have to recraft the query to be an update -- not hard, just annoying (unless I cant, in which case, the exporting of a list of pks into a update is more painful).
Love the software otherwise.
Christopher Steven Tobey
shared this idea
AdminDevart
(_, Devart)
responded
This can be achieved with the functionality implemented in the new version by right-clicking in the data grid and selecting ‘Generate Script As → UPDATE’ from the popup menu.
-
Christopher Steven Tobey
commented
That generates a list of update statements, one per row... which defeats the purpose of generating the script (since I would just have to update the values of each statement to the same thing for all rows anyway). The goal is to update a batch of rows to a single value. right-click --> Set Value To --> is perfect, except it only has 4 default options (
0, NULL, NOW(), '') but I often want to batch update to other values (1, an ENUM value, etc). This request is really to have another "Set Value To" option to set it to an arbitrary value. It would be extra nice if it would detect when Enum rows are being changed and keep the dropdown, but I can live with a little typing.