Bitwise shift in mysql

Question

How can I make a bitwise shift in MySQL? Is there any specific instruction or operator? If not, how to simulate it optimally?

Answer 1

Have a look at the bitwise operators in MySQL first: http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html

Then you have left shift:

http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html#operator_left-shift

And right shift:

http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html#operator_right-shift

Answer 2

To use a bitwise shift in MySQL, you can use << or >> for left shift or right shift respectively.