POW() - X Raised to Power of Y

Q

How to calculate the exponential of a number on a given base using the POW() function?

✍: FYIcenter.com

A

POW(X, Y) is a MySQL built-in function that calculates the exponential of a number on a given base. For example:

SELECT POW(2, 0.5), POW(2, 3), POW(2.718, -1.0);
  -- +--------------------+-----------+---------------------+
  -- | POW(2, 0.5)        | POW(2, 3) | POW(2.718, -1.0)    |
  -- +--------------------+-----------+---------------------+
  -- | 1.4142135623730951 |         8 | 0.36791758646063283 |
  -- +--------------------+-----------+---------------------+

Reference information of the POW() function:

POW(X, Y): val
  Returns the value of X raised to the power of Y.

Arguments, return value and availability:
  X: Required. The base value.
  Y: Required. The power value.
  val: Return value. The X raised to Y.
  Available since MySQL 4.0.

Related MySQL functions:

 

POWER() - Synonym for POW()

PI() - Value of PI, π

MySQL Functions on Numeric Values

⇑⇑ MySQL Function References

2023-11-14, 266🔥, 0💬