Skip to content

Instantly share code, notes, and snippets.

@dickyaryag6

dickyaryag6/do-update-int

Created September 5, 2021 06:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dickyaryag6/139860b7a2b3e744e64fa8ece903fd56 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dickyaryag6/139860b7a2b3e744e64fa8ece903fd56 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
do-update-int
INSERT INTO person
(name, country, job, age)
values ('Mike', 'England', 'Software Engineer', 5)
ON CONFLICT (name)
DO UPDATE SET age = person.age + EXCLUDED.age;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment