Let's Share Our KNOWLEDGE

update table temp set `a`=`a`+1 , `b`= `a`+ 1; this query sometimes doesn't yield the result we are actually looking for.. so the problem is `a` is getting updated first. So, the actual query should be : update table temp set `b`= `a`+ 1, `a`=`a`+1 ;

redis-cli keys "sess*" | while read LINE ;do echo `redis-cli EXPIRE $LINE 10000`; done; NOTE: "sess*" will be replaced by the key name and 10000 will be replaced by time you want to set for expiry (will be in seconds)