SQL Update with Where

SQL Update with Where clause having condition to update particular record.
Take a table Student

StudentID StudentName StudentCity
1 Rahul Chandigarh
2 Karan Mohali
3 Neha Delhi
4 Manpreet Chandigarh
5 Ajay Delhi


Update Query



UPDATE Student
SET StudentCity='Mumbai'
WHERE StudentName='Rahul';



StudentID StudentName StudentCity
1 Rahul Mumbai
2 Karan Mohali
3 Neha Delhi
4 Manpreet Chandigarh
5 Ajay Delhi

Back To Top