Collections:
POW() - X Raised to Power of Y
How to calculate the exponential of a number on a given base using the POW() function?
✍: FYIcenter.com
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:
2023-11-14, 266🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...