Skip to main content

Updatable Views

Learn Updatable Views (Views, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction An updatable view lets you run INSERT , UPDATE and DELETE against it and MySQL forwards the change to the single base table. It must have a clear one-to-one mapping to rows.

More lessons in Views