AnalyticDB for MySQL supports the following arithmetic operators.

+ Addition.
- Subtraction.
* Multiplication.
/ Division.
DIV Integer division.
% or MOD Modulo.
- Changes the sign of the argument.

+

  • Description: This operator is used for addition.
  • Example:
    select 3+5;
    +-------+
    | _col0 |
    +-------+
    |     8 | 
    select 3+2.9875;
    +--------+
    | _col0  |
    +--------+
    | 5.9875 |

-

  • Description: This operator is used for subtraction.
  • Example:
    select 3-5;
    +-------+
    | _col0 |
    +-------+
    |    -2 |
    select 3-1.5;
    +-----------+
    | _col0     |
    +-----------+
    | 1.5       |

*

  • Description: This operator is used for multiplication.
  • Example:
    select 3*pi();
    +------------------+
    | _col0            |
    +------------------+
    | 9.42477796076938 |

/

  • Description: This operator is used for division.
  • Example:
    select 3/pi();
    +-------------------+
    | _col0             |
    +-------------------+
    | 0.954929658551372 |

DIV

  • Description: This operator is used for division. The decimal part of the result is discarded.
  • Example:
    select 3 div pi();
    +-------+
    | _col0 |
    +-------+
    |     0 |
    select 33 div 2;
    +-------+
    | _col0 |
    +-------+
    |    16 |

% or MOD

  • Description: This operator returns the remainder of one argument divided by the other argument.
  • Example:
    select 3 mod pi();
    +-------+
    | _col0 |
    +-------+
    |   3.0 |
    select 33 % 2;
    +-------+
    | _col0 |
    +-------+
    |     1 |

-

  • Description: This operator converts a positive number to a negative number or a negative number to a positive number.
  • Example:
    select - 2;
    +-------+
    | _col0 |
    +-------+
    |    -2 |
    select - -2;
    +-------+
    | _col0 |
    +-------+
    |     2 |