log

description

Syntax

DOUBLE log(DOUBLE b, DOUBLE x) 返回基于底数bx的对数.

example

  1. mysql> select log(5,1);
  2. +---------------+
  3. | log(5.0, 1.0) |
  4. +---------------+
  5. | 0 |
  6. +---------------+
  7. mysql> select log(3,20);
  8. +--------------------+
  9. | log(3.0, 20.0) |
  10. +--------------------+
  11. | 2.7268330278608417 |
  12. +--------------------+
  13. mysql> select log(2,65536);
  14. +-------------------+
  15. | log(2.0, 65536.0) |
  16. +-------------------+
  17. | 16 |
  18. +-------------------+

keywords

  1. LOG