You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The only way to create views as of now is to use the SQL tab and type in your statement. I think the reason that there is no dialog for it is that the creation of a view is basically a SELECT statement:
CREATEVIEW `my_view` ASSELECT ...
A SELECT statement, however, can be quite complex and at least I don't have an idea on how to design an efficient UI for it.
What you can do, by the way, is typing a SELECT statement in the SQL tab, execute it, have a look at the results, repeat this procedure if needed, and eventually click on the Save button near the results table which allows you to create a view from this select statement,
Activity
MKleusberg commentedon May 27, 2014
The only way to create views as of now is to use the SQL tab and type in your statement. I think the reason that there is no dialog for it is that the creation of a view is basically a SELECT statement:
A SELECT statement, however, can be quite complex and at least I don't have an idea on how to design an efficient UI for it.
What you can do, by the way, is typing a SELECT statement in the SQL tab, execute it, have a look at the results, repeat this procedure if needed, and eventually click on the Save button near the results table which allows you to create a view from this select statement,
justinclift commentedon Jun 1, 2014
No worries. That'll work for now. We can think of ways to construct stuff visually later on if people ask for it. 😄