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 |`