Collections:
LOG() - Logarithm of Y to Base X
How to calculate the logarithm of a number to a given base number using the LOG() function?
✍: FYIcenter.com
LOG(X, Y) is a MySQL built-in function that calculates the logarithm of Y to base X. For example:
SELECT LOG(2, 1024), LOG(2, 1.4142), LOG(2.718, 0.3679); -- +--------------+--------------------+---------------------+ -- | LOG(2, 1024) | LOG(2, 1.4142) | LOG(2.718, 0.3679) | -- +--------------+--------------------+---------------------+ -- | 10 | 0.4999861644218742 | -1.0000478060991969 | -- +--------------+--------------------+---------------------+
Reference information of the LOG() function:
LOG(Y, X): val Returns the logarithm of X to the base Y. If X is less than or equal to 0, or if Y is less than or equal to 1, then NULL is returned. If called with one parameter Y, this function returns the natural logarithm of Y. Arguments, return value and availability: Y: Required. The base value, if X is provided. It becomes a synonym for LN(Y), if X is not provided. X: Optional. The input value, if provided. val: Return value. The logarithm of the input value. Available since MySQL 4.0.
Related MySQL functions:
⇒ LOG10() - Logarithm to Base 10
2023-11-15, 244🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...