Entering SQL Commands - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 184

The multi-dimensional arrays used for holding some
parameters in the configuration file reflect a programming
style adopted by the phpMyAdmin development team. This
avoids having very long parameter names.
Views
MySQL 5.0 introduced support for named, updatable views. phpMyAdmin's current
version partially supports views.
Creating a View
To create a view, we use the query box to manually enter the appropriate statement.
Let's enter the following statement and click Go :
CREATE VIEW books_authors AS
SELECT books.isbn, books.title, authors.author_name FROM books
LEFT JOIN authors USING ( author_id )
At this point, the view has been created, even if the left panel has not been updated
to reflect this fact. If we refresh our browser's page and then access the dbbook
database, we see:
In the left panel, there is a different symbol next to the books_authors 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 has been computed, and View is
indicated in the Type column. There is no collation or size associated with a view.