SQL UPDATE 

This statement is  to modify/Update the existing records in a table.

Student table:

Syntax:

Example : 

Update student set name='om', contact='8596874858' WHERE regno=1001;

The OUTPUT for the above query:

UPDATE MULTIPLE RECORDS

Here, Where clause decides how many rows or records will get updated.

Following statement will updated the name to om where state is karnataka

Example:

UPDATE student set name='om' WHERE state='Karnataka';

The OUTPUT for the above query:

When you update any record, you must be careful and use the WHERE condition. If you dont use the WHERE condition all the records will get updated.

Example:

UPDATE Student SET state='karnataka';

The OUTPUT for the above query:

IF you want to update a single record use Where condition.