Skip to content
← Customer Feedback for Devart

Settings and activity

1 result found

  1. Multirow update in data viewer

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  dbForge Studio for MySQL » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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.

    An error occurred while saving the comment
    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.

    Christopher Steven Tobey shared this idea  ·