DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Operator Precedence

Info Catalog (mysql.info.gz) Non-typed Operators (mysql.info.gz) Non-typed Operators (mysql.info.gz) Parentheses
 
 12.1.1 Operator Precedence
 --------------------------
 
 Operator precedences are shown in the following list, from lowest
 precedence to the highest. Operators that are shown together on a line
 have the same precedence.
 
      :=
      ||, OR, XOR
      &&, AND
      NOT
      BETWEEN, CASE, WHEN, THEN, ELSE
      =, <=>, >=, >, <=, <, <>, !=, IS, LIKE, REGEXP, IN
      |
      &
      <<, >>
      -, +
      *, /, DIV, %, MOD
      ^
      - (unary minus), ~ (unary bit inversion)
      !
      BINARY, COLLATE
 
 The precedence shown for `NOT' is as of MySQL 5.0.2.  For earlier
 versions, or from 5.0.2 on if the `HIGH_NOT_PRECEDENCE' SQL mode is
 enabled, the precedence of `NOT' is the same as that of the `!'
 operator.   Server SQL mode.
 
Info Catalog (mysql.info.gz) Non-typed Operators (mysql.info.gz) Non-typed Operators (mysql.info.gz) Parentheses
automatically generated byinfo2html