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.