Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Feature Request: One-click-favorite-query-execute Buttons

forums forums SQLyog SQLyog: Bugs / Feature Requests Feature Request: One-click-favorite-query-execute Buttons

This topic contains 1 reply, has 0 voices, and was last updated by  peterlaursen 4 years, 7 months ago.

  • Author
    Posts
  • #13267

    First of all, i love SQLYog (using ultimate version 12.01).

     

    Im using it all day long administrating about 200 different databases. One administrative task involves sending a favorite Query to one of the databases and display (and edit) the result. Of course i use the “Favorites” function to fetch a Query and then execute it on a target database.

     

     

     

    This is my feature request:

    If i could execute a pre defined Query in a one click manner it would save me (and other DB-admins out there) several hours of “unnecessary clicking” each week or even each day!

     

    For example; In the GUI (under Tools –> Preferences for instance) you could add custom buttons to the toolbar which would be dedicated to the simple task of executing a pre defined Query.

     

     

    Is this something you could discuss adding in a future release?

     

    Thank you in advance.

     

    Regards,

    Robert

  • #35073

    Mitch
    Participant

    Great idea!  Perhaps tie it to the existing Favorites list so that they could be executed with a toolbar button and/or key combination. 

    Bonus would be the ability to have a favorite execute on all currently connected servers.

  • #35074

    peterlaursen
    Participant

    well  .. we can only execute a query from inside a query tab (or – when saved to a file –  from menu .. tools .. execute SQL script but in that case the results from SELECT and SHOW statements do not display).

     

    A displayed result set in SQLyog is a ‘child’ of the Query tab that holds the query and a result set cannot display otherwise. What we could do is to add a context menu to favorites “open in new query tab and execute” or similar. However I think wtih session restore of recent versions there is another solution.  Just have a (or more) saved session with the queries you execute routinedly.

You must be logged in to reply to this topic.