Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

update 2 columns in table at same time

SOLVED
Go to solution
Ratzie
Super Advisor

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'
2 REPLIES
A. Clay Stephenson
Acclaimed Contributor
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.
Ratzie
Super Advisor

Re: update 2 columns in table at same time

wrong syntax!