O'Reilly logo

MySQL 5.0 Certification Study Guide by Carsten Pedersen, Stefan Hinz, Paul DuBois

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

14 Views

A view is a database object that is defined in terms of a SELECT statement that retrieves the data you want the view to produce. Views are sometimes called “virtual tables.” A view can be used to select from regular tables (called “base tables”) or other views. In some cases, a view is updatable and can be used with statements such as UPDATE, DELETE, or INSERT to modify an underlying base table.

This chapter covers the following exam topics:

Image The benefits of using views

Image Creating, altering, and dropping views

Performing validity checks ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required