View in MySQL-Data manipulation

First, new data

Insert into view name [(field list)] VALUES (list of values);

Note:

1. Multiple table views cannot add data.

2. A single table view has a base table all fields that cannot be empty or have no default values can add data.

Ii. deletion of data

Delete from view name [where condition];

Note: Multiple table views cannot delete data.

Third, update the data

Theoretically, multiple tables and single-table views can update data.

You can add update restrictions when you create a view: With CHECK option

Create view table name as SELECT statement where condition with CHECK option;

--Add a view of the update limit, and when updating the data, you must ensure that the updated value is still within the where condition, otherwise it cannot be updated.

View in MySQL-Data manipulation