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;

Post a Comment

0 Comments