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!
1Updates existing data in a table.
2Example: Updates the mileage and serviceDue values for a vehicle with an
3id of 45 in the cars table.
4UPDATE cars
5SET mileage = 23500, serviceDue = 0
6WHERE id = 45;