Skip to content

Support UPDATE ... FROM #1283

@fulghum

Description

@fulghum

The FROM clause in the UPDATE statement allows multiple tables to be joined together and updated. PostgreSQL Docs

Example:

update delivery_attempts set repo_id_fk = webhooks.repo_id_fk from delivery_attempts da inner join webhooks on da.webhook_id_fk = webhooks.id where delivery_attempts.id = da.id;

Discovered while testing DoltHub import

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions