Mysql Numeric Functions

What are the Numeric Functions In MySQL?

Explanation

MySQL Numeric Functions :


Numeric function consists of two main sections. They are : Now, lets first discuss about Arithmetic operations.
MySQL Arithmetic Operations :
In MySQL, we have the usual Arithmetic operations. Lets see the arithmetic operators one by one with an example.

Example :


MySQL Addition (+) :
mysql> select 5+5;
--> 10
MySQL Subtraction (-) :
mysql> select 25-18;
--> 7
MySQL Multiplication (*) :
mysql> select 4*4;
--> 16
MySQL Division (/) :
mysql> select 5/3;
--> 1.67
The above descriptions defines the types of MySQL Numeric Functions and Their Uses.
Next lets move to the Mathematical functions.


Ask Questions

Ask Question