Update Command

   We can use the UPDATE command for modifying the data.

Syntax:

UPDATE "table_name" SET "column_1" = [new value] WHERE {condition}

Example:

UPDATE Store_Information SET Sales = 500 WHERE store_name = "Los Angeles"AND Date = "Jan-08-1999".