What is the function of operator <<,>> and <=> in mysql

Asked Jun 08 '18 at 13:49

Active Jun 08 '18 at 14:49

Viewed 41 times

-3

<<,>> and <=> when these operators are used.

edited Jun 08 '18 at 14:49

asked Jun 08 '18 at 13:49

B L Praveen

1,636
4
28
48

2

https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html, https://stackoverflow.com/questions/21927117/what-is-this-operator-in-mysql – ADyson Jun 08 '18 at 13:53
>>, << is it a comparison operator ? – B L Praveen Jun 08 '18 at 14:08
@BLPraveen Did you read the links? `<>` are no comparison operators. – Ivar Jun 08 '18 at 14:26

1 Answers1

1

>> is right shift opperator. https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html#operator_right-shift

<=> is Null safe comparator https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#operator_equal-to

answered Jun 08 '18 at 13:52

Juan Carlos Oropeza

45,789
11
74
113