SQL UPDATE

The UPDATE Statement is used to modify the existing records in a table.

The Syntax is:

UPDATE table_name  SET column1 = value1, column2 = value2, ...
[WHERE condition]

Example:

UPDATE student SET  fname = 'Khadim' WHERE lname= 'Hussain'

 
OR

UPDATE student SET  fname = 'Abdul', lname= 'Basit', dob='10/11/1983'

WHERE reg_no='1003'