Suppose there is a situation in which
There is column named pass/fail.which has default values 1/0
Respectively.
Now by mistake you have inserted it as 0 for pass and 1 for fail.
Now you need to update but you cannot do it easily because,
If i write query like this "update result set pass=1 where pass=0"
or update result set fail=0 where fail=1
this will surely create a havoc.
So, we need to toggle both bit values at a time
For which you can write it as
update result set pass=pass ^1
this is called XOR operation
This will do the task happy Querying...:-)
Sunday, April 11, 2010
Subscribe to:
Post Comments (Atom)
This is a kool idea...i never knew this...
ReplyDeletebut if it is a bit..
instead if it would have been an integer and you wanted to swap...
for eg. You want to swap 1 and 2 with each other..how would you do that...