Syntax for multiple updates

admin

Administrator
Staff member
i know how to update one part of a record at a time, example
UPDATE phone_list SET number='555-5555' where first_name='John';

what would be the syntax if i wanted to, oh, update his last name in the same command?

thanks in advance
marty
 
Back
Top