0
quarry to update name in a row?
2 Answers
0
Update TableName
set ColumnName=Value
where[condition];
0
for ex:
Table name Student
Columns and it's data
studentId studentname
1 Ajay
if you want to update studentname Ajay to Jay then query is
update student
set studentname='Jay'
where studentID=1;
Result:
studentId studentname
1 Jay