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

Copy Query Sql To Query Builder?

forums forums SQLyog Using SQLyog Copy Query Sql To Query Builder?

Tagged: 

This topic contains 1 reply, has 0 voices, and was last updated by  maxhugen 3 years, 10 months ago.

  • Author
    Posts
  • #13380

    maxhugen
    Participant

    Is there a way to get a query, in SQL, into the Query Builder?

     

    I created a query in the Builder, and from there created a View. Now I want to modify the View, but I’d prefer to use the Builder to change the query in the View.

     

    This would be similar to MS Access, where you can swap from “Builder” view to SQL view – and back again.

  • #35412

    peterlaursen
    Participant

    There is no way.  This would require a SQL parser inside SQLyog. This would be a huge task as it would have to be written from scratch, since we cannot clone the parser code from the server (for license/legal reasons). 

  • #35413

    maxhugen
    Participant

    Hi Peter

     

    Understand what you’re saying.

     

    Gotta say though, whilst almost every IT pro I know, or have read online, sneers at the mention of MS Access, it’s still KING of RAD. It’s more than 20 years now since Access could parse SQL into it’s QBE!

     

    Cheers, Max

You must be logged in to reply to this topic.