MySQL Math LOG() Function

<< Back to MYSQL

next → ← prev MySQL LOG() Function The Log() is a Math function of MySQL. This function is used to return either the natural logarithm of the given number if it has one parameter or specified base logarithm number if it has two parameters. Syntax select Log(number); Select log(base, number); Parameters: number : It is the number for getting natural logarithm value. base: It is the base of the natural logarithm. Returns This function returns the natural logarithm of the given number. Note: If the number is less than or equal to 0, this function will return NULL. If the base is less than or equal to 1, this function will return NULL. Example 1 Select log(5); Output: Example 2 Select log(-25); Output: Example 3 Select log(45.2); Output: Next TopicMySQL Math ← prev next →

Related Links:

• MySQL Create Database
• MySQL DAYOFWEEK() Function
• MySQL DAYOFYEAR() Function
• MySQL From_days() Function
• MySQL Hour() Function
• MySQL ADDTIME() Function
• MySQL CURRENT_TIME() Function
• MySQL CURRENT_TIMESTAMP() Function
• MySQL last_day() Function
• MySQL localtime() Function
• MySQL localtimestamp() Function
• MySQL makedate() Function
• MySQL maketime() Function
• MySQL microsecond() Function
• MySQL minute() Function
• MySQL month() Function
• MySQL vs SQL
• MySQL monthname() Function
• MySQL now() Function
• MySQL period_add() Function
• MySQL period_diff() Function
• MySQL quarter() Function
• MySQL sec_to_time() Function
• MySQL Sysdate() Function
• MySQL second() Function
• MySQL Subdate() Function
• MySQL Subtime() Function
• MySQL time() Function
• MySQL time_to_sec() Function
• MySQL time_format() Function
• MySQL to_day() Function
• MySQL timediff() Function
• MySQL timestamp() Function
• MySQL weekday() Function
• MySQL Math SIN() Function
• MySQL week() Function
• MySQL weekofyear() Function
• MySQL Math
• MySQL Math ABS() Function
• MySQL Math ACOS() Function
• MySQL Math SIGN() Function
• MySQL Math SQRT() Function
• MySQL Math SUM() Function
• MySQL Math TAN() Function
• MySQL Math ATAN2() Function
• MySQL Drop Table
• MySQL View
• MySQL Queries
• MySQL Insert Statement
• MySQL Update Statement
• MySQL Math TRUNCATE() Function
• MySQL Math ASIN() Function
• MySQL Math ATAN() Function
• MySQL Math MIN() Function
• MySQL Math AVG() Function
• MySQL Math CEIL() Function
• MySQL Math CEILING() Function
• MySQL Math COS() Function
• MySQL Math COT() Function
• MySQL Math COUNT() Function
• MySQL Math DEGREES() Function
• MySQL Math DIV() Function
• MySQL Math EXP() Function
• MySQL Math FLOOR() Function
• MySQL Math GREATEST() Function
• MySQL Math LEAST() Function
• MySQL Math LN() Function
• MySQL Math LOG10() Function
• MySQL Math LOG() Function
• MySQL Math LOG2() Function
• MySQL Math MAX() Function
• MySQL Math MOD() Function
• Learn MySQL Tutorial
• MySQL Math PI() Function
• MySQL Math POWER() Function
• MySQL Math POW() Function
• MySQL Math RADIANS() Function
• MySQL Math RAND() Function
• MySQL Math ROUND() Function
• MySQL String
• MySQL String CONCAT_WS() Function
• MySQL String CHARACTER_LENGTH() Function
• MySQL String CONCAT() Function
• MySQL String ELT() Function
• MySQL String EXPORT_SET() Function
• MySQL String RTRIM() Function
• MySQL String FIELD() Function
• MySQL String FIND_IN_SET() Function
• MySQL String FORMAT() Function
• MySQL String FROM_BASE64() Function
• MySQL String HEX() Function
• MySQL String INSERT() Function
• MySQL String INSTR() Function
• MySQL String LCASE() Function
• MySQL String LEFT() Function
• MySQL String LENGTH() Function
• MySQL String like() Function
• MySQL String LOAD_FILE() Function
• MySQL String LOCATE() Function
• MySQL String LOWER() Function
• MySQL String LPAD() Function
• MySQL String LTRIM() Function
• MySQL String MAKE_SET() Function
• MySQL String MID() Function
• MySQL String OCTET_LENGTH() Function
• MySQL String OCT() Function
• MySQL String ORD() Function
• MySQL String POSITION() Function
• MySQL String QUOTE() Function
• MySQL String REPEAT() Function
• MySQL String REPLACE() Function
• MySQL String REVERSE() Function
• MySQL String SPACE() Function
• MySQL String RIGHT() Function
• MySQL String RPAD() Function
• MySQL String SOUNDEX() Function
• MySQL String UNHEX() Function
• MySQL String UCASE() Function
• MySQL String STRCMP() Function
• MySQL String SUBSTR() Function
• MySQL String SUBSTRING_INDEX() Function
• MySQL String SUBSTRING() Function
• MySQL String Trim() Function
• MySQL String UPPER() Function
• MySQL Drop Database
• MySQL Create Table
• MySQL Alter Table
• MySQL Truncate Table
• MySQL Delete Statement
• MySQL Select Statement
• MySQL Group By Clause
• Top 58 MySql Interview Questions (2021)
• MySQL Features
• MySQL Data Types
• MySQL regexp_like() function
• MySQL regexp_replace() Function
• MySQL regexp_substr() function
• MySQL Select Database
• MySQL Where Clause
• MySQL Distinct Clause
• MySQL From Clause
• MySQL Order By Clause
• MySQL Having Clause
• MySQL AND Condition
• MySQL average()
• MySQL min()
• MySQL max()
• MySQL Literals
• MySQL OR Condition
• MySQL AND and OR Condition
• MySQL IS NULL Condition
• MySQL LIKE Condition
• MySQL IN Condition
• MySQL NOT Condition
• MySQL IS NOT NULL Condition
• MySQL first()
• MySQL BETWEEN Condition
• MySQL Join
• MySQL count()
• MySQL sum()
• MySQL last()
• MySQL Comments
• MySQL not regexp Operator
• MySQL Regexp Operator
• MySQL regexp_instr() function
• MySQL Cursor
• MySQL Functions
• MySQL Date and Time
• MySQL PROCEDURE
• MySQL Trigger
• MySQL not like Operator
• MySQL date/time
• MySQL DATE() Function
• MySQL DATE_ADD() Function
• MySQL ADDDATE() Function
• MySQL CURDATE() Function
• MySQL CURRENT_DATE() Function
• MySQL DATE_FORMAT() Function
• MySQL DATEDIFF() Function
• MySQL DAY() Function
• MySQL CURTIME() Function
• MySQL DAYNAME() Function
• MySQL DAYOFMONTH() Function
• MySQL str_to_date() Function

Related Links