August 13, 2008
Creating a View with MySQL Query Browser
Author: JT Smith
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.