Math functions in MySQL

We can use various mathematical functions available in MySQL queries to handle our numeric data in a table. We can update our data with new data or use them in our script as per our requirements. We will discuss some of the important math functions used frequently in queries for MySQL table.
Functions Description
maxWe can find out maximum value from a field of mysql table by using max command
minMinimum value among records can be found out by using min sql command
sumOur query can return sum of numeric data present in a record
avgWe can get the average value of a range of data by using avg function.
floorMath floor function to get highest integer value.
ceilMath ceil function to get lowest integer value.
countCounting the number of records in a table with conditions
ModGetting the reminder of a division and using in our Query
Second highestWE can display first and second highest number present in table by using limit and order by commands
Data formatGetting the formatted output from mysql table by using format query.
sqrtSquare root of number
powPower of a number & creating a square table
Your Rating



iwant learn math using php and mysql

Post Comment This is for short comments only. Use the forum for more discussions.

HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us
©2000-2017 All rights reserved worldwide Privacy Policy Disclaimer