Update - LanceDB

Applies to: Embedded ❌, Enterprise ✅

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.

What to read next

Update

The SDK equivalent.