Skip to content

Instantly share code, notes, and snippets.

@sfdcale
Created November 11, 2021 05:47
Show Gist options
  • Select an option

  • Save sfdcale/d4a80cb4f315be1cabb9de827a00122f to your computer and use it in GitHub Desktop.

Select an option

Save sfdcale/d4a80cb4f315be1cabb9de827a00122f to your computer and use it in GitHub Desktop.
Sqlite - Syntax for UPDATE FROM
UPDATE
Employee
SET
Id = T2.Id // DO NOT USE Employee.Id HERE. IT FAILS.
FROM
(
SELECT
Department.Id AS Id
FROM
Department
) AS T2
WHERE
Employee.Id = T2.Id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment