UPDATE

Definition:

To update record(s) in the table.

---

Command Syntax:

UPDATE table_name SET
field1_name = field1_new_value,
field2_name = field2_new_value,
field3_name = field3_new_value,
...
fieldN_name = fieldN_new_value
[WHERE criteria];

• Update all record(s) in the existing table called table_name with giving new value for every specific field if no setting criteria
• Update record(s) that meets the criteria in the existing table called table_name with giving new value for every specific field if setting criteria
• WHERE criteria refers to WHERE - SQL statement

---

'UPDATing my eyes.'By secondary 6 student