From the course: MySQL Essential Training (2019)
Unlock this course with a free trial
Join today to access over 22,500 courses taught by industry experts.
Logarithms - MySQL Tutorial
From the course: MySQL Essential Training (2019)
Logarithms
- [Instructor] MySQL provides these basic log rhythm functions. We can select LN of two and this will give us the natural log rhythm of the number two. This is a simple version of the log function. The log function itself does exactly the same thing if you just give it one argument, but it also allows another argument, so say if I give it 10 and 100, this will return the log rhythm of 100 to the base of the first argument, so that gives us two, on the other hand, if I give it two comma 65535, it gives us an approximation of 16, so it's returning the log rhythm of the second argument to the base of the first argument, likewise, there is a function called LOG2, which will just give us a base two log rhythm and so that gives us the same value there, and there's also a LOG10, so if I give this 100 here this gives us the same result as LOG10 comma 100. The inverse of LOG is EXP, so if I give this a one, it returns the value E, so this returns the value E raised to the power of the provided…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.