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.

Link: packtpub.com

Category:

  • Databases
Click Here!