• Learning MySQL By Example
  • Introduction
  • 1. How to Retrieve Data From a Single Table
  • 2. How to Retrieve Data from Multiple Tables
  • 3. Using Functions
  • 4. How to Insert, Update, Delete Data in Tables
  • 5. Summary Queries and Aggregate Functions
  • 6. Working With Subqueries
  • 7. SQL Views
  • 8. SQL Indexes
  • Glossary
  • Index
  • Download
  • Translations
  • 7.1

    SQL View Explained

    SQL Views

    • A SQL view is a SELECT statement that is stored as a database object.
    • A SQL view acts as a virtual table but contains no data.
    • You can use a view anywhere you would use a table including in a SELECT, INSERT, UPDATE, or DELETE statement.

    This content is provided to you freely by EdTech Books.

    Access it online or download it at https://edtechbooks.org/learning_mysql/the_elements_of_a_vi.