update two columns at time

[rahul8626]

I have two columns failcount and login i have to update them together.
How should i use update query.

[debasisdas]

I have two columns failcount and login i have to update them together.
How should i use update query.

update <tablename> set failcount=value ,login='login_n ame' where <your condition>

[amitpatel66]

Hi Rahul8626,

Welcome to TSDN!!

Please make sure you follow POSTING GUIDELINES when ever you post in this forum

Thanks
MODERATOR

[subashsavji]

I have two columns failcount and login i have to update them together.
How should i use update query.

update emp
set empno=1000,enam e='djdj'
where ename='jjjj';