MySQL LOG10() function
In this context, we will learn how we can use the MySQL LOG10() function with proper syntax and good examples.
Introduction of MySQL LOG10() function
To evaluate the natural logarithmic value of a mentioned number with base 10, we can use the LOG10() function in MySQL.
It will return NULL when the number is greater than 0.
Syntax of the MySQL LOG10() function
The syntax of the MySQL LOG10() function is given as follows:
LOG10(Y);
Parameters or arguments used in MySQL LOG10() function:
Only one parameter is accepted by LOG10() function, as mentioned above in the syntax and described below as follows.
Y– This is the number whose logarithm value with base e we want to calculate. It should be a positive number.
Returns:
It will return the natural logarithm of the given number Y with base 10.
The application used for LOG10() function:
The LOG10() function can be used in the given below MySQL versions:
- MySQL 5.7
- MySQL 5.6
- MySQL 5.5
- MySQL 5.1
- MySQL 5.0
- MySQL 4.1
- MySQL 4.0
- MySQL 3.23
Examples of MySQL LOG10() function:
Now, we will look into some examples of MySQL LOG10 functions.
Example 1:
Here, we will find the logarithm of the given numbers with base 10 using the LOG10() function in MySQL.
SELECT LOG10(1000) AS LOG10_Val;
Output:
LOG10_VAL
3
1 row in set (0.00 sec)
Example-2 :
Here, we will find the logarithm of 0 with base e using the LOG10() function in MySQL.
SELECT LOG10(0) AS LOG10_Val ;
Output:
LOG10_VAL
NULL
1 row in set (0.00 sec)
Example 3:
When we require to find the base 10 logarithmic value of a column data, then we can take the help of the LOG10 function. For demonstration, we have created a table named commodity.
CREATE TABLE Commodity(
Commodity_id INT AUTO_INCREMENT,
Commodity_name VARCHAR(100) NOT NULL,
Buying_price DECIMAL(13, 2) NOT NULL,
Selling_price DECIMAL(13, 2) NOT NULL,
Service_grade Decimal(6, 2) NOT NULL,
PRIMARY KEY(Commodity_id)
);
Now we will insert some data to the Commodity table –
INSERT INTO
Commodity(Commodity_name, Buying_price, Selling_price, Service_grade)
VALUES
('Touring Bike, '2019.00, 3009.6, 5.89 ),
('Mountain Bike,' 3019.50, 4000.56, 10.00 ),
('Road Bike,' 1019.20, 2000.56, -0.89 ),
('Road Bicycle,' 1419.50, 1800.56, -1.50 ),
('Racing Bicycle,' 3000.50, 4500.56, 5.00) ;
Now it will show all the commodity table data with the help of the following query -
Select * from Commodity;
| COMMODITY_ID | COMMODITY_NAME | BUYING_PRICE | SELLING_PRICE | SERVICE_GRADE |
| 1 | Touring Bike | 2019.00 | 3009.6 | 5.89 |
| 2 | Mountain Bike | 3019.50 | 4000.56 | 10.00 |
| 3 | Road Bike | 1019.20 | 2000.56 | -0.89 |
| 4 | Road Bicycle | 1419.50 | 1800.56 | -1.50 |
| 5 | Racing Bicycle | 3000.50 | 4500.56 | 5.00 |
Now, we are going to find the logarithmic values with base 10 for all the records present in the Service_grade column.
Select Commodity_id, Commodity_name, Buying_price,
Selling_price, Service_grade, LOG10(Service_grade) AS GRADELOG10
FROM Commodity;
Output:
| COMMODITY_ID | COMMODITY_NAME | BUYING_PRICE | SELLING_PRICE | SERVICE_GRADE | GRADELOG10 |
| 1 | Touring Bike | 2019.00 | 3009.6 | 5.89 | 0.7701152947871016 |
| 2 | Mountain Bike | 3019.50 | 4000.56 | 10.00 | 1 |
| 3 | Road Bike | 1019.20 | 2000.56 | -0.89 | NULL |
| 4 | Road Bicycle | 1419.50 | 1800.56 | -1.50 | NULL |
| 5 | Racing Bicycle | 3000.50 |
Summary:
In this context, we have learned how we can use the MySQL LOG10() function to find the LOG10 values from given arguments respectively.