update_with_from_join.sql
· 80 B · MySQL
Raw
UPDATE table1
SET table1.c1 = new_value
FROM table2
WHERE table1.c2 = table2.c2;
| 1 | UPDATE table1 |
| 2 | SET table1.c1 = new_value |
| 3 | FROM table2 |
| 4 | WHERE table1.c2 = table2.c2; |