How can one issue multiple Update commands in one command?

Databases
1

Hi,

How can one issue multiple Update commands in one command rather a separate Update command
for each Updated wanted?

For example conceptually something like this:
EXECUTE ((update traffic_xch imp_del = imp_del + 1 where id = 900),
(update traffic_xch imp_del = imp_del + 1 where id = 905)
(update traffic_xch imp_del = imp_del + 1 where id = 909)
);

Regards,

2

This works just fine :slight_smile:
ThanX.

3

a number of choices, this being easiest for your example.

UPDATE
traffic_xch
SET imp_del = imp_del + 1 where id in (900,905,909)