MySQL POWER() function
In this context, we will learn how we can use the MySQL POWER() function with proper syntax and good examples.
Introduction of MySQL POWER() function
The value of a number raised to the power of another number is derived by the POWER function in MySQL. It Returns the value of P raised to the power of Q.
Syntax of the MySQL POWER() function
The syntax of the MySQL POWER() function is given as follows:
POWER(P, Q)
Parameters or arguments used in MySQL POWER() function:
There are two parameters accepted by the POWER() function in MySQL, which are given as follows:
• P: The base number is specified by it.
• Q: The exponent number is specified by it.
Returns:
It will return the value of P raised to the power of Q.
Application used for POWER() function:
The POWER() 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 POWER() function:
Now we will look into some MySQL POWER() function examples and will explore how we can use the POWER function in MySQL.
Example-1:
Now we will derive the Power value when both base and exponent are positive using MySQL's POWER() function.
SELECT POWER( 4, 3) AS Power_Value ;
Output:
Power_Value
64
1 row in set (0.00 sec)
Example-2:
Now we will derive the Power value when the base is positive, but the exponent is negative using MySQL's POWER() function.
SELECT POWER( 2, -4) AS Power_Value ;
Output :
Power_Value
0.0625
Example-3:
In this example, we will derive the Power value when the base is negative, but the exponent is positive using the POWER() function in MySQL.
SELECT POWER( -5, 3) AS Power_Value ;
Output :
Power_Value
-125
Example-4:
In this example, we will derive the Power value when both base and exponent are negative using the POWER() function in MySQL.
SELECT POWER( -3, -4) AS Power_Value ;
Output :
Power_Value
0.012345679012345678
Example-5:
When we require to find the power value between column data, then we can take the help of the POWER function. To demonstrate, we have created a table named Trigonal.
CREATE TABLE Trigonal(
Type VARCHAR(25) NOT NULL,
NoOfSides INT NOT NULL,
Base INT NOT NULL,
Height INT NOT NULL
);
Now we will add some data into the Trigonal table :
INSERT INTO
Trigonal(Type, NoOfSides, Base, Height )
VALUES
('Right-angled Triangle,' 3, 4, 3 ),
('Right-angled Triangle,' 3, 2, 5 ),
('Right-angled Triangle,' 3, 1, 7 ),
('Right-angled Triangle,' 3, 7, 9 ),
('Right-angled Triangle,' 3, 4, 6 ),
('Right-angled Triangle,' 3, 8, 3 ),
('Right-angled Triangle,' 3, 10, 10 ) ;
Showing all data of Trigonal Table –
Select * from Trigonal ;
| Type | NoOfSides | Base | Height |
| Right-angled Triangle | 3 | 4 | 3 |
| Right-angled Triangle | 3 | 2 | 5 |
| Right-angled Triangle | 3 | 1 | 7 |
| Right-angled Triangle | 3 | 7 | 9 |
| Right-angled Triangle | 3 | 4 | 6 |
| Right-angled Triangle | 3 | 8 | 3 |
| Right-angled Triangle | 3 | 10 | 10 |
Now, we are going to find the hypotenuse and area for each Right-angled Triangle.
SELECT
*,
sqrt(POWER(Base, 2) + POWER(Height, 2)) AS Hypotenuse,
0.5 * Base * Height as Area
FROM Trigonal;
Output :
| Type | NoOfSides | Base | Height | Hypotenuse | Area |
| Right-angled Triangle | 3 | 4 | 3 | 5 | 6.0 |
| Right-angled Triangle | 3 | 2 | 5 | 5.385164807134504 | 5.0 |
| Right-angled Triangle | 3 | 1 | 7 | 7.0710678118654755 | 3.5 |
| Right-angled Triangle | 3 | 7 | 9 | 11.40175425099138 | 31.5 |
| Right-angled Triangle | 3 | 4 | 6 | 7.211102550927978 | 12.0 |
| Right-angled Triangle | 3 | 8 | 3 | 8.54400374531753 | 12.0 |
| Right-angled Triangle | 3 | 10 | 10 | 14.142135623730951 | 50.0 |
Summary:
In the above context, we have learned how we can use the POWER() function in MySQL used to find the value of a number raised to the power of another number.