> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-structure/operators/arithmetic-operators.md).

# Arithmetic Operators

{% columns %}
{% column %}
{% content-ref url="/pages/iMHS5R597IQLPxJtRfrj" %}
[Addition Operator (+)](/docs/server/reference/sql-structure/operators/arithmetic-operators/addition-operator.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Add two operands with the + operator, calculating integer results at BIGINT precision and letting the highest-precision operand determine the result type for real or string values.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Av3glOb9RqiGJV3DWcnW" %}
[Subtraction Operator (-)](/docs/server/reference/sql-structure/operators/arithmetic-operators/subtraction-operator.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Subtract one operand from another with the - operator, which also serves as the unary minus for changing sign, computing integer results at BIGINT precision.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/qRRylsY5hlvGULE4MaKi" %}
[Multiplication Operator (\*)](/docs/server/reference/sql-structure/operators/arithmetic-operators/multiplication-operator.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Multiply two operands with the \* operator.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/sRxEtQBjX4J6RnYyGRdm" %}
[Division Operator (/)](/docs/server/reference/sql-structure/operators/arithmetic-operators/division-operator.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Divide operands with the / operator, returning NULL on division by zero and controlling decimal digits with the div\_precision\_increment system variable.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/SLyxcMaEX8i2D9GiXUao" %}
[Modulo Operator (%)](/docs/server/reference/sql-structure/operators/arithmetic-operators/modulo-operator.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Return the remainder of N divided by M with the % modulo operator.
{% endcolumn %}
{% endcolumns %}