Be careful of chain statement in Update SQL!

The ‘colon and comma’ logic in the program fragment

UPDATE SCUSTOM SET: DISCOUNT
= ’003′,

TELEPHONE = ’0621/444444′

WHERE ID

= ’00017777′.

defines statement chains,

NOT through a single statement which updates the discount and thetelephone number of the customer with the customer number ’00017777′,

BUT by means of two statements where the first updates the discountfor ALL customers and the second changes the telephone number of the customer with the customer number ’00017777′.

Comments are closed.