how to update the data base or change the data in roww at matched row only]

if u see, we want to change the srikant name to some other name and age to some other age

using this we can update that

chage the data

update database1.studentinfo SET firstname ='raju', age =35 where name =1;

name =1, matches at that set or updata the values by given column headers with value

update databasename.tablename set columnheader='data', columnheader =data in number where selectrow='string' or numer;

update dummy.studentinfo set username='un5', password ='pw5' where name=1

update set where