SQL Tutorial SQL Advanced SQL Database SQL References

MySQL POW() Function



The MySQL POW() function returns the base raise to the power of exponent. In special cases it returns the following:

  • If the exponent is zero, then 1 is returned.

The POW() function is a synonym for the POWER() function.

Syntax

POW(base, exponent)

Parameters

base Required. Specify the base.
exponent Required. Specify the exponent.

Return Value

Returns the base raise to the power of exponent.

Example 1:

The example below shows the usage of POW() function.

mysql> SELECT POW(5, 2);
Result: 25

mysql> SELECT POW(3, 5);
Result: 243

mysql> SELECT POW(5.5, 2);
Result: 30.25

mysql> SELECT POW(5.5, 2.1);
Result: 35.87250030349099

mysql> SELECT POW(5, -1);
Result: 0.2

mysql> SELECT POW(5, 0);
Result: 1

mysql> SELECT POW(0, 5);
Result: 0

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 10.5
Data 21
Data 35
Data 410
Data 550

The statement given below can be used to calculate the square root of column x.

SELECT *, POW(x, 0.5) AS POW_Value FROM Sample;

This will produce the result as shown below:

DataxPOW_Value
Data 10.50.7071067811865476
Data 211
Data 352.23606797749979
Data 4103.1622776601683795
Data 5507.0710678118654755

Example 3:

Consider a database table called Sample with the following records:

Dataxy
Data 10.52
Data 213
Data 354
Data 4103
Data 5503

To calculate the records of column x raised to the power of records of column y, the following query can be used:

SELECT *, POW(x, y) AS POW_Value FROM Sample;

This will produce the result as shown below:

DataxyPOW_Value
Data 10.520.25
Data 2131
Data 354625
Data 41031000
Data 5503125000

❮ MySQL Functions