Arithmetic Operators : Operator « Select Clause « SQL / MySQL

1. SQL / MySQL
2. Select Clause
3. 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