|
Numeric Functions :
Numeric function consists of two main sections. They are :
Now, lets first discuss about Arithmetic operations.
Arithmetic Operations :
In MySQL, we have the usual Arithmetic operations. Lets see the arithmetic operators one by one with an example.
Addition (+) :
mysql> select 5+5;
--> 10
Subtraction (-) :
mysql> select 25-18;
--> 7
Multiplication (*) :
mysql> select 4*4;
--> 16
Division (/) :
mysql> select 5/3;
--> 1.67
Next lets move to the Mathematical functions.
| 
