Multi-Table Update
This lesson shows how we can update several tables at the same time.
We'll cover the following...
Multi-Table Update
We have an equivalent of updating multiple tables just as we can delete from multiple tables.
Syntax
UPDATE T1, T2
SET col1 = newVal1, col2 = newVal2
WHERE <condition1>
Connect to the terminal below by ...