1--update query example
2 UPDATE table_name
3 SET column1 = value1, column2 = value2, ...
4 WHERE condition;
1UPDATE table_name
2SET column1 = value1, column2 = value2...., columnN = valueN
3WHERE [condition];
4
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