topic update 2 columns in table at same time in Operating System - HP-UX

update 2 columns in table at same time

Ratzie — Fri, 17 Jun 2005 13:18:48 GMT

can this be done?
UPDATE table1 SET CUSTOMER = 'Customer1' set ph_num = '1234567' where address = '123 address'

A. Clay Stephenson — Fri, 17 Jun 2005 13:34:00 GMT

Yes, with the proper syntax.

UPDATE table1
SET customer = 'Customer 1', ph_num = '1234567'
WHERE address = '123 address';

Ratzie — Fri, 17 Jun 2005 13:36:00 GMT

wrong syntax!