Databases Reference
In-Depth Information
Clicking on
Go
produces a results page, where we see a
CREATE VIEW
link in the
Query results operations
section. We use this link to access the view creation panel,
which already has the underlying query in the
AS
box. We need to choose a name for
this view (here, we use
book_public_info
), and we can optionally set different column
names for it (here, we use
number, title
), as shown in the following screenshot:
The other options can influence the view's behavior, and have been explained in
the My
SQL manual (
http://dev.mysql.com/doc/refman/5.5/en/crea
te-view.
html
). The
LOCAL CHECK OPTION
clause influences the behavior of the updateable
views (this is explained in the MySQL manual at the page cited previously).
Search WWH ::
Custom Search