ADD()

Overview

Return the sum of two numbers.

USAGE

ADD([number,] number)

Argument Name

Description

number

Two numbers to add together or one number to treat as a positive value

DETAILS

ADD() is a mathematical function that adds two numbers together.

If the optional first argument is not provided, it defaults to 0.

A NULL is returned if either argument is NULL.

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

SELECT ADD(25, 17), ADD(99);
+-------------+---------+
| ADD(25, 17) | ADD(99) |
+-------------+---------+
|          42 |      99 |
+-------------+---------+

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.09

  • Present starting in MariaDB Xpand 23.09.1.

6.1

  • Present starting in MariaDB Xpand 6.1.0.

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.1

  • Present starting in MariaDB Xpand 6.1.0.

EXTERNAL REFERENCES