Updatable VIEWs

Insert, update and delete through some views.

Updatable VIEW

Simple VIEWs allow INSERT, UPDATE and DELETE through them.

UPDATE active_customers SET status = 'vip' WHERE id = 1;

This query updates customer status through the VIEW.

In active_customers, status = 'vip' is updated. Only the rows where id = 1 holds are affected.

Updatable VIEWs must be simple: no JOIN, GROUP BY or DISTINCT.

For example, in a single-table view like active_customers, UPDATE … SET status = 'vip' updates the customers table directly.

Set status to 'vip' for id=1 through the active_customers VIEW.

Show example solution

UPDATE active_customers SET status = 'vip' WHERE id = 1;

Add UPDATE

____ active_customers SET status = 'vip' WHERE id = 1;

Show answer

UPDATE active_customers SET status = 'vip' WHERE id = 1;