|
--2nd query of 2, using temp defined in earlier step.
|
|
--(not used in demo)
|
|
UPDATE temp set account = 'Bob' where id in (221130, 222138,222146);
|
|
UPDATE temp set account = 'Alice' where id = 231248;
|
|
update temp set account = 'Bank' where account = 'UNKNOWN';
|
|
select * from temp;
|
|
|