Databases Reference
In-Depth Information
At this point, the view has been created and the left panel is updated to reflect this fact.
If we refresh our browser's page, and then access the marc_book database, we see:
In the left panel, there is a different icon next to the book_author view; it can be used
to browse this view. In the right panel, we see the newly created view's information.
The number of records for the view currently indicates 0 (more on this in the
Performance Hint section, later in this chapter), and View is indicated in the Type
column. There is no collation or size associated with a view.
This creation step was done manually; other operations on views are handled by
phpMyAdmin's interface.
Right Panel and Views
Since a view has similarities compared to a table, its name is available in the
navigation panel, among the names of ordinary tables. After clicking on this view's
name, a panel similar to the one seen for tables is displayed, but with fewer menu
tabs than for a normal table. Indeed, some operations do not make sense on a view,
for example, Import , because a view does not really contain data, but other actions
are perfectly acceptable, such as Browse .
Let's browse this view:
 
Search WWH ::




Custom Search