View is a logical table based on one or more tables or views. A view contains no data itself, but retrieves it from underlying tables and views when requested. Views are introduced in MySQL 5.0.1.
Fusion for MySQL allows you to create, modify, and drop views, retrieve and alter data in underlying tables.
Save the document. If there are any errors in the SQL syntax, you will be notified about it.
Edit a view by selecting Edit View on the Database Explorer node shortcut menu. In the opened document, you can alter the query text. Once a view is created, you can not modify its name or owner. Save the document to apply changes you’ve made to the query text.
Drop a view by selecting Delete on the Database Explorer node shortcut menu.
To retrieve view data, right-click on view in Database Explorer and choose Retrieve Data on the shortcut menu. The data is rendered in grid-based editor. You can browse and edit view data in the same way as you browse and edit table data.
Some views can be non-updatable. You can not edit their data.