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