...

/

Multi-Table Update

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 ...