外观
本页尚未翻译
本页内容仍为英文原文，源自官方文档 sql/dml/update。中文翻译正在分批进行中。
Update
UPDATE ... SET ... WHERE, and why it does not recompute derived columns.
Applies to: Embedded ❌, Enterprise ✅
sql
UPDATE documents SET title = upper(title) WHERE category = 'film'Assignments take any expression the dialect supports, including references to other columns of the same row. Without a WHERE clause every row is updated.
注意
An update does not recompute computed columns that derive from the column you changed. Those rows keep the value computed from the old input until the next refresh recomputes them. See Guarantees.
Commits a new table version, so versioning and the write guarantees apply, including that the version advances even when the statement affects zero rows.