Arithmetic Operators : Operator « Select Clause « SQL / MySQL

1.	Aggregate Functions
2.	Backup Load
3.	Command MySQL
4.	Cursor
5.	Data Type
6.	Database
7.	Date Time
8.	Engine
9.	Event
10.	Flow Control
11.	FullText Search
12.	Function
13.	Geometric
14.	I18N
15.	Insert Delete Update
16.	Join
17.	Key
18.	Math
19.	Procedure Function
20.	Regular Expression
21.	Select Clause
22.	String
23.	Table Index
24.	Transaction
25.	Trigger
26.	User Permission
27.	View
28.	Where Clause
29.	XML

SQL / MySQL » Select Clause » Operator

Arithmetic Operators

      

mysql>

mysql> SELECT 2+1;

+-----+

| 2+1 |

+-----+

|   3 |

+-----+

1 row in set (0.00 sec)



mysql>

mysql> SELECT 4-2/4;

+--------+

| 4-2/4  |

+--------+

| 3.5000 |

+--------+

1 row in set (0.00 sec)



mysql>

mysql> SELECT 4-(2/4);

+---------+

| 4-(2/4) |

+---------+

|  3.5000 |

+---------+

1 row in set (0.00 sec)



mysql>

Related examples in the same category

1.	Comparison Operators
2.	Comparison operators 2
3.	Sort Operators
4.	special <=> operator, which is like = except that it works with NULL operands by treating them as any other va
5.	Compare NULL with <=> operator
6.	Not operator
7.	or operator vs in operator
8.	Comparison Operators and null
9.	Use the basic mathematical operators
10.	In operator and a long list of integer
11.	Less than and equals(<=) operators with All operator
12.	Reversing or Negating Query Conditions
13.	Not equal

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.