how to update row in sql

1--update query example
2 UPDATE table_name
3 SET column1 = value1, column2 = value2, ...
4 WHERE condition; 

1UPDATE TABLE
2   SET EndDate = CAST('2009-05-25' AS DATETIME)
3 WHERE Id = 1

1UPDATE table_name
2SET column1 = value1, column2 = value2...., columnN = valueN
3WHERE [condition];
4

1SQL> UPDATE CUSTOMERS
2SET ADDRESS = 'Pune'
3WHERE ID = 6;

1//to update value
2
3UPDATE students SET course_id = 102
4WHERE last_name = 'Jones'; -> 
5                 if there is no condition it will update all!

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