Update Command

Update Command

Used to change the contents of existing rows

• The UPDATE clause identifies the table containing the records to be changed.
• The SET clause identifies the columns to be changed and the new values to

be assigned to these columns.

• The optional WHERE clause identifies the exact records to be changed by the

UPDATE command. If the WHERE clause is omitted, the column specified in the SET clause is updated for all records in the table.

Back To Top- Home - Category