Math functions in MySQL
SELECT ABS(-12.5) AS absolute_value, ROUND(18.567, 2) AS rounded_value, POW(2, 5) AS power_value;| Functions | Description |
| ABS() | Absolute value of a number |
| ACOS | Arc cos of the input |
| ASIN | Arc sin of the input |
| ATAN | Arc tan of the input |
| ATAN2 | Arc tan of two inputs |
| AVG | We can get the average value of a range of data by using avg function. |
| CEIL() | Math ceil function to get lowest integer value. |
| CONV() | Convert one base to another |
| COS() | COS() function takes input in Radian |
| COT() | COT() function takes input in Radian |
| COUNT | Counting the number of records in a table with conditions |
| CRC32() | CRC32() returns 32 bit unsigned value of a string |
| DEGREES | Convert Radian value to Degree |
| EXP | e raised to the power of X |
| FLOOR() | Math floor function to get highest integer value. |
| LN | Log of the number (Same as LOG()) |
| LOG | Log of the number with different Base value |
| LOG10 | Log of the number with fixed Base 10 value |
| LOG2 | Log of the number with fixed Base 2 value |
| MAX | Maximum value from a field of MySQL table by using max command |
| MIN | Minimum value among records by using MIN Query |
| Mod | Getting the remainder of a division and using in our Query |
| PI() | PI() value with different functions |
| POW() | Power of a number & creating a square table |
| RADIANS() | Converting Degree to Radians in our Query |
| RAND() | Generate a pseudo-random floating-point value |
| ROUND() | Rounded to decimals |
| SIGN | Sign of the argument |
| SIN | Sin of a radian input |
| SUM | Our query can return sum of numeric data present in a record |
| TAN | Tan of a radian input |
| Second highest | We can display first and second highest number present in table by using limit and order by commands |
| Data format | Getting the formatted output from MySQL table by using format query. |
| SQRT() | Square root of number |
| TRUNCATE() | Converting to fixed decimal value |
| STDDEV() | Standard Deviation |
| VARIANCE() | Variance |
Practice Questions
- Retrieve the absolute value of the difference between two numbers: 16 and -35.
- Calculate the square root of the average of the numbers 35, 29, and 84.
- Round the number 11.8765 to two decimal places.
- Calculate the value of 2 raised to the power of 7.
- Find the remainder when 27 is divided by 4.
- Generate a random decimal number between 10 and 50.
- Calculate the natural logarithm of 100.
- Round down the number 15.9 to the nearest integer.
- Calculate the value of e (Euler's number) raised to the power of 3.
- Find the ceiling value of the result of dividing 47 by 5.
Subhendu Mohapatra
Author & Instructor at plus2net
I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.
Connect:
Subscribe to our YouTube Channel here
This article is written by plus2net.com team.
https://www.plus2net.com
| mohamed | 24-07-2014 |
| iwant learn math using php and mysql | |
SQL Video Tutorials