MySQL POW() function
In this context, we will learn how we can use the MySQL POW() function with proper syntax and good examples.
Introduction of MySQL POW() function
This function in MySQL is used to return a result after raising a specified exponent number to a mentioned base number.
For example, if the base is 5 and the exponent is 2, this will return a result of 25.
Syntax of the MySQL POW() function
The syntax of the MySQL POW() function is given as follows:
SELECT POW(P, Q);
Parameters or arguments used in MySQL POW() function:
There are two parameters accepted by the POW() function in MySQL, which are given as follows:
P: It is the mentioned base number.
Q: It is the mentioned exponent number.
Returns:
It will return a result after raising a specified exponent number to a specified base number.
Application used for POW() function:
The POW() function can be used in the given below MySQL versions.:
- MySQL 5.7
- MySQL 5.6
- MySQL 5.5
- MySQL 5.1
- MySQL 5.0
- MySQL 4.1
- MySQL 4.0
- MySQL 3.23
Examples of MySQL POW() function:
Now we will look into some MySQL POW() function examples and will explore how we can use the POW function in MySQL.
Example 1:
Here, we will derive the result of 64 for the base value 8 and exponent value 2 using the POW function in MySQL.
SELECT POW(8, 2);
Output:
64
1 row in set (0.00 sec)
Example 2:
Here, we will derive the result of 4 for 2 as the base and exponent value using the POW function in MySQL.
SELECT POW(2, 2);
Output:
4
1 row in set (0.00 sec)
Example 3:
Here, we will derive the result of 1 for the base value 6 and exponent value 0 using the POW function in MySQL.
SELECT POW(6, 0);
Output:
1
1 row in set (0.00 sec)
Example 4:
Here, we will derive the result of 0 for the base value 0 and exponent value 4 using the POW function in MySQL.
SELECT POW(0, 4);
Output:
0
1 row in set (0.00 sec)
Application of MySQL POW() function:
This function is used to return a result after raising a specified exponent number to a specified base number.
Summary:
In the above context, we have learned how to use the POW() function in MySQL to return a result after raising a specified exponent number to a mentioned base number.