MySQL Query Browser :: 9 Using The MySQL Query Browser :: 9.3 Creating Views
Section Navigation [Toggle]
- 9 Using The MySQL Query Browser
- 9.1 Entering and Editing Queries Manually
- 9.2 Building Queries
- 9.3 Creating Views
- 9.4 Navigating Result Sets Within the Result Area
- 9.5 Exporting Result Sets
- 9.6 Handling BLOB and TEXT Columns
- 9.7 Editing Result Sets Within the Result Area
- 9.8 Comparing Result Sets
- 9.9 Managing Stored Procedures and Functions with MySQL Query Browser
- 9.10 Editing Queries From a Development Tool
- 9.11 Using the Regex Text Importer Tool
The simplest way to create a view using the MySQL Query Browser is to use the Create View button. Execute a query that represents the view you wish to create. Once the query is executed, click the Create View button, provide a name for the view, and the view is created.
Note
Creating views is not yet supported on all Operating systems.
You can also create a view by right-clicking on the database you wish to add a view to in the database browser and choosing the Create New View option. After you enter a name for the view, a view template will be displayed in the script editor.
