POW
Returns the given number exponentiated to the given power.
Syntax
POW ( number, power ) POWER ( number, power )
Arguments
expression: any valid numeric expression.
power: any valid numeric expression.
Return Type
Float or double. If either argument is null, returns NULL
.
Examples
SELECT POW(2, 8); **** +-----------+ | POW(2, 8) | +-----------+ | 256 | +-----------+
SELECT POW(2, 16); **** +------------+ | POW(2, 16) | +------------+ | 65536 | +------------+
SELECT POW(2, 24); **** +------------+ | POW(2, 24) | +------------+ | 16777216 | +------------+
SELECT POW(2, 2.5); **** +-------------------+ | POW(2, 2.5) | +-------------------+ | 5.656854249492381 | +-------------------+