19.1 UPDATE Rows

Update is one operation in CRUD. The SQL statement for updating one or more existing rows is the UPDATE statement.

UPDATE [tablename]
  SET [colname]=[new_value]
  WHERE [row-selecting condition]