MySQL POW() Function

The POW() function in MySQL calculates the result of raising a number to a specified power (exponent). This is a fundamental mathematical operation used in various calculations.

POW(): Definition and Usage

POW() takes two numbers as input: the base number and the exponent. It returns the base number raised to the power of the exponent (base^exponent). This function is very useful for a wide range of mathematical computations and data manipulations. It is equivalent to the POWER() function.

Syntax


POW(x, y)

Parameter Values

Parameter	Description
`x`	The base number (the number being raised to a power). This is required.
`y`	The exponent (the power). This is required.

Examples

Raising a Number to a Power

This example calculates 4 raised to the power of 2 (4² = 4 * 4 = 16).

Syntax


SELECT POW(4, 2);

Output

Raising Another Number to a Power

This example calculates 8 raised to the power of 3 (8³ = 8 * 8 * 8 = 512).

Syntax


SELECT POW(8, 3);