Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
-- first update (birth)
UPDATE public.artists
SET birth_year = 1907
WHERE artist_id = 299;
-- second update (death)
UPDATE public.artists
SET death_year = 1989
WHERE artist_id = 299;
-- third update (middle initial)
UPDATE public.artists
SET name = 'Gerhard M. Bakker'
WHERE artist_id = 299;
-- fourth update (nationality - impacts partitions)
UPDATE public.artists
SET nationality = 'German'
WHERE artist_id = 299;
-- fifth update (birth)
UPDATE public.artists
SET birth_year = 1905
WHERE artist_id = 299;
-- delete
DELETE
FROM public.artists
WHERE artist_id = 299;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment