sql - Does deleting row from view delete row from base table - MySQL?

Question

Deleting a row from a view, will it delete the appropriate rows from the base tables that the view was created upon? I am using MySQL.

Answer 1

Yes, it will. The only thing to watch out for, is permissions.

Quoting official docs

Some views are updatable. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. For a view to be updatable, there must be a one-to-one relationship between the rows in the view and the rows in the underlying table. There are also certain other constructs that make a view nonupdatable.