SQL UPDATE QUERY


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

Syntax:
UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];

Example

idnamesalary
11Ashwani2000
12Sachin3000
13Deepak20000
14Soun200
UPDATE student SET salary='3000' WHERE name= 'Soun'
Output
idnamesalary
11Ashwani2000
12Sachin3000
13Deepak20000
14Soun3000

Share this article on