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;
0 Comments