First page Back Continue Last page Image

What Happens if you try to Update a Calculated Field?

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