Updating in mysql
In the above example, the SET section of the statement identifies the column to be updated and the value to which it is to be changed.
The WHERE section of the statement identifies the row, or rows to be updated.
Without a WHERE condition, the update will be applied to every row in the table.
Secondly, it needs to know which columns are to be updated, and the new values for those columns.
Finally, it needs information about which specific rows are to be updated (controlled by the WHERE keyword).
However, to create an updatable view, the SELECT statement that defines the view must not contain any of the following elements: If you create a view with the TEMPTABLE algorithm, you cannot update the view.
Note that it is sometimes possible to create updatable views based on multiple tables using an inner join.