UPDATE balance_due_view
SET balance_due = 0
WHERE invoice_number = '9982771'
Error Code: 1348. Column 'balance_due' is not updatable
Here is the UPDATE Command, but the View Field balance_due is calculated
As a result we will get an error from MySQL