SQL PHP HTML ASP JavaScript articles and free scripts to download
SQL

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

Number of User Comments : 1


Google+

mohamed24-07-2014
iwant learn math using php and mysql
Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



Join Our Email List
Email:  
For Email Newsletters you can trust

HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer