Bitwise shift in mysql

问题:

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

回答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

回答2:

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

回答3:

Looks like there is shift operators available, ie >> for right shift.