1UPDATE employees
2SET
3 address = '1300 Carter St',
4 city = 'San Jose',
5 postalcode = 95125,
6 region = 'CA'
7WHERE
8 employeeID = 3;
9
1UPDATING ROW
2Update TableName set ColumnName = value where condition;
3update scrumteam set firstname =‘Martin' where EmployeeID='1';
4update scrumteam set lastname =‘Murtin' where firstname='Tom’;
5