Question

Which of the following is the correct order of precedence (high to low)?

(a) !, ^, <<, XOR

(b) ^, !,  <<, XOR

(c) !,  <<, XOR, ^

(d) !, ^, XOR,  <<

I got this question during an interview.

Origin of the question is Expression Evaluation and Type Conversion in division Data Types of MySQL

Answer 1

Right choice is (a) !, ^, <<, XOR

Best explanation: When MySQL evaluates an expression, it looks at the operators to determine the order in which it should group the terms of the expression. Some operators have higher precedence, and evaluated earlier than others.