SQL Update Statement

SQL UPDATE Query

In SQL Update Statement are used to change or modify the existing record in table

UPDATE Syntax-The Basic Syntax For update table are as Follows

SQL>UPDATE table_nameSET column1 = value1, column2 = value2 WHERE condition;

Example- UPDATE Table

SQL> UPDATE Student SET StudentName = 'Shyam', City= 'GorakhPur' WHERE RollNo = 10;

In Above Example It Update The Student name and City whose Rollno is 10

Example

SQL>UPDATE Student SET StudentName = 'Shyam' WHERE RollNo = 10;