Istvan

SQL bitwise

Aug 21st, 2012
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.25 KB | None | 0 0
  1. UPDATE userActivations SET attribs = (attribs|2);
  2. SELECT * FROM userActivations;
  3.  
  4. UPDATE userActivations SET attribs = (attribs|32);
  5. SELECT * FROM userActivations;
  6.  
  7. UPDATE userActivations SET attribs = (attribs&(~2));
  8. SELECT * FROM userActivations;
Advertisement
Add Comment
Please, Sign In to add comment