gaiety revised this gist 2 days ago. Go to revision
No changes
gaiety revised this gist 2 days ago. Go to revision
1 file changed, 4 insertions
update_with_from_join.sql(file created)
| @@ -0,0 +1,4 @@ | |||
| 1 | + | UPDATE table1 | |
| 2 | + | SET table1.c1 = new_value | |
| 3 | + | FROM table2 | |
| 4 | + | WHERE table1.c2 = table2.c2; | |
Newer
Older