EC
1249
MySQLERRORNotableViewsHIGH confidence

Column in view with expression cannot be updated

Production Risk

Low — update is rejected; refactor to use base table.

What this means

ER_NONUPDATEABLE_COLUMN (1249, SQLSTATE HY000) is raised when an UPDATE or INSERT targets a column in a view that is derived from an expression rather than a direct column reference, making it non-updatable.

Why it happens
  1. 1Updating a view column that is defined as an expression (e.g., col1 + col2)
  2. 2Updating a view column derived from a function call
How to reproduce
trigger — this will error
trigger — this will error
CREATE VIEW v1 AS SELECT id, price * 1.1 AS adjusted_price FROM products;
UPDATE v1 SET adjusted_price = 100 WHERE id = 1;  -- ERROR 1249

expected output

ERROR 1249 (HY000): Column 'adjusted_price' is not updatable

Fix

Update the underlying base table directly

Update the underlying base table directly
UPDATE products SET price = 100 / 1.1 WHERE id = 1;

Why this works

Expression columns in views cannot be written to; modify the base table directly.

Sources
Official documentation ↗

MySQL 8.0 — 1249 ER_NONUPDATEABLE_COLUMN

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MySQL errors