HPE Community
Operating System - HP-UX
1753396 Members
7227 Online
108792 Solutions
New Discussion юеВ

Re: update 2 columns in table at same time

 
SOLVED
Go to solution
Ratzie
Super Advisor

тАО06-17-2005 06:18 AM

тАО06-17-2005 06:18 AM

update 2 columns in table at same time

can this be done?
UPDATE table1 SET CUSTOMER = 'Customer1' set ph_num = '1234567' where address = '123 address'
0 Kudos
2 REPLIES 2
A. Clay Stephenson
Acclaimed Contributor

тАО06-17-2005 06:34 AM

тАО06-17-2005 06:34 AM

Solution

Re: update 2 columns in table at same time

Yes, with the proper syntax.

UPDATE table1
SET customer = 'Customer 1', ph_num = '1234567'
WHERE address = '123 address';
If it ain't broke, I can fix that.
0 Kudos
Ratzie
Super Advisor

тАО06-17-2005 06:36 AM

тАО06-17-2005 06:36 AM

Re: update 2 columns in table at same time

wrong syntax!
0 Kudos
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.