Is it possible to run query builder against a view?

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
dims
Posts: 3
Joined: Fri 01 Jul 2016 12:51

Is it possible to run query builder against a view?

Post by dims » Fri 01 Jul 2016 12:52

Is it possible to run query builder against a view?

I can design SQL files with graphical query builder.

Can I do the same with views (which are just stored queries on server side)?

alexa

Re: Is it possible to run query builder against a view?

Post by alexa » Fri 01 Jul 2016 13:12

You can design queries with views on the Query Builder diagram as well as with tables.

dims
Posts: 3
Joined: Fri 01 Jul 2016 12:51

Re: Is it possible to run query builder against a view?

Post by dims » Tue 12 Jul 2016 09:51

How? I don't see a way.

Here is an example of a view, opened in sample database. Only textual representation visible:

Image

Where is the button to call builder?

Here is an example of the same query, opened from SQL file. You can see explicit builder button:

Image

alexa

Re: Is it possible to run query builder against a view?

Post by alexa » Tue 12 Jul 2016 10:33

Please right-click in the editor and select 'Design SQL...' in the popup menu.

dims
Posts: 3
Joined: Fri 01 Jul 2016 12:51

Re: Is it possible to run query builder against a view?

Post by dims » Tue 12 Jul 2016 12:49

Ah, that worked, thanks!

alexa

Re: Is it possible to run query builder against a view?

Post by alexa » Tue 12 Jul 2016 13:35

Please let us know if any questions arise.

Post Reply