Creating a View with MySQL Query Browser

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, which I will demonstrate in this article: From an existing query and writing from scratch, manually.