Chapter 5. Views, Intro
Prev
Next
Chapter 5. Views, Intro
Table of Contents
References for this Lesson
MySQL 5.0 Views, Intro
SQL Schema Part, First Example
Views? What for?
1. Simply a Copy of a Base Table
2. Column Name and Expressions
3. Where, Order, Group, etc.
4. Update, Delete, and Insert
5. Expressions etc
6. Views of Views
Formalities
Views as Opposed to Tables, Updatability
When is a View Not Updatable?
Views and Insertability
Examples of Non-Insertability
Assignments
A Word on Handing In Assignments
Assignment F.0
Assignment F.1
Assignment F.2
Assignment F.3
Assignment F.4
Assignment F.5
Assignment F.6
References for this Lesson
[
Pel08
] Through page 26. Stop at
Check Table
.