Published at LXer:
When you’re creating a query for non-technical users and you don’t want them to see the complexity of the query, you can create a view from the query. Your users can then use the view as a table; for example, they can double-click the view, which will effectively execute its complex query behind the scene. In MySQL Query Browser, you have two ways to create a view, From an existing query and Writing from scratch manually
Read More...