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.