Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- May be PostgreSQL-centric
- CREATE TEMPORARY TABLE newvalues AS VALUES
- (1 AS user_id, 'newname' AS user_name),
- (2 AS user_id, 'newOthername' AS user_name);
- UPDATE users
- SET users.name = newvalues.user_name
- FROM newvalues
- WHERE newvalues.user_id = users.id;
Add Comment
Please, Sign In to add comment