MySQL - Addition Operator (+)

MySQL performs operations on its data using various types of operators. It supports arithmetic operators, comparison operators, logical operators, assignment operators, etc. However, only arithmetic operators deal solely with numeric values.

Arithmetic operators are used to perform operations such as addition, subtraction, multiplication, division and modulus operations on the data stored in MySQL; where the Addition Operator (+) is used to add two numbers.

The addition operator can be used with the SELECT, UPDATE, and DELETE statements in MySQL, along with clauses like WHERE, ORDER BY etc.

Syntax

Following is the syntax of MySQL MOD operator −

[SELECT|DELETE|UPDATE] x + y;

Where, "x" and "y" are placeholders for the numeric values you want to add.

Example

In the following example, we are using the "+" operator to add two ordinary numbers and display the result in the form of a result-set −

SELECT 4156456 + 56445;

Output

This will produce the following result −

4156456 + 56445
4212901

Example

Let us see another example where we are adding three fractional numbers (or values with float datatype) using the following statement −

SELECT 547.5478 + 657.3547 + 5475;

Output

This will produce the following result −

547.5478 + 657.3547 + 5475
6679.9025

Example

Until now, we just saw addition between ordinary values. We can also add values in a MySQL table column using '+' operator with the SELECT statement.

To do so, let us first create a table named CUSTOMERS using the following query −

CREATE TABLE CUSTOMERS (
   ID INT AUTO_INCREMENT,
   NAME VARCHAR(20) NOT NULL,
   AGE INT NOT NULL,
   ADDRESS CHAR (25),
   SALARY DECIMAL (18, 2),
   PRIMARY KEY (ID)
);

The following query adds 7 records into the above created table −

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY) VALUES 
(1, 'Ramesh', 32, 'Ahmedabad', 2000.00 ),
(2, 'Khilan', 25, 'Delhi', 1500.00 ),
(3, 'Kaushik', 23, 'Kota', 2000.00 ),
(4, 'Chaitali', 25, 'Mumbai', 6500.00 ),
(5, 'Hardik', 27, 'Bhopal', 8500.00 ),
(6, 'Komal', 22, 'Hyderabad', 4500.00 ),
(7, 'Muffy', 24, 'Indore', 10000.00 );

Execute the below statement to display all the records present in the CUSTOMERS table −

Select * From CUSTOMERS;

Following is the CUSTOMERS table −

ID NAME AGE ADDRESS SALARY
1 Ramesh 32 Ahmedabad 2000.00
2 Khilan 25 Delhi 1500.00
3 Kaushik 23 Kota 2000.00
4 Chaitali 25 Mumbai 6500.00
5 Hardik 27 Bhopal 8500.00
6 Komal 22 Hyderabad 4500.00
7 Muffy 24 Indore 10000.00

Now, we are using the + operator to add the age and salary of every customer −

SELECT NAME, AGE + SALARY as RESULT FROM CUSTOMERS;

Output

On executing the given query, the output is displayed as follows −

NAME RESULT
Ramesh 2032.00
Khilan 1525.00
Kaushik 2023.00
Chaitali 6525.00
Hardik 8527.00
Komal 4522.00
Muffy 10024.00

Example

You can also use the addition operator with DELETE statement. In such cases, we use WHERE clause along with assignment operators.

This query deletes rows from the CUSTOMERS table where the sum of the AGE and SALARY columns is less than 5000 −

DELETE FROM CUSTOMERS WHERE (AGE + SALARY) < 5000;

Output

Four records has been deleted from CUSTOMERS table −

Query OK, 4 rows affected (0.01 sec)

Verification

Execute the below query to check whether the above operation is succesful or not −

SELECT * FROM CUSTOMERS;

As shown in the output below, the customers whose combined age and salary is below 5000 have been deleted from the table.

ID NAME AGE ADDRESS SALARY
4 Chaitali 25 Mumbai 6500.00
5 Hardik 27 Bhopal 8500.00
7 Muffy 24 Indore 10000.00

Example

Along with SELECT and DELETE statements, you can also use the addition operator with the UPDATE statement.

In this query, we are updating the NAME to 'Hrithik' for customers whose combined "AGE" and "SALARY" is greater than 8000 −

UPDATE CUSTOMERS
SET NAME = 'Hrithik'
WHERE (AGE + SALARY) > 8000;

Output

This will produce the following result −

Query OK, 2 rows affected (0.01 sec)
Rows matched: 2  Changed: 2  Warnings: 0

Verification

Execute the below query to check whether the above operation is succesful or not −

SELECT * FROM CUSTOMERS;

As we can see in the below table, the name has been to 'Hrithik' for two records −

ID NAME AGE ADDRESS SALARY
4 Chaitali 25 Mumbai 6500.00
5 Hrithik 27 Bhopal 8500.00
7 Hrithik 24 Indore 10000.00
Advertisements