Versions Compared

Old Version 7

changes.mady.by.user Kevin Day

Saved on

compared with

New Version 8

changes.mady.by.user Kevin Day

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
titleMulti-Insert Update SQL
UPDATE table AS t SET
  field1 = v.field1,
  field2 = v.field2
FROM (values
  (1, 'field1 row1', 'field2 row1'),
  (2, 'field1 row2', 'field2 row2')
) AS v(id, field1, field2)
WHERE v.id = u.id;

...