MySQL – Numeric Functions MySQL – Numeric Functions MySQL numeric functions are used primarily for numeric manipulation and/or mathematical calculations. The following table details the numeric functions that are available in the MySQL. Sr.No. Name & Description 1 Returns the absolute value of numeric expression. 2 Returns the arccosine of numeric expression. Returns NULL if […]
Author Archives: user
MySQL – String Functions MySQL – String Functions MySQL string functions are used to manipulate the string values. The following table details the string functions that are available in the MySQL. Sr.No. Name & Description 1 This function returns numeric value of left-most character. 2 This function returns a string representation of the argument. 3 […]
MySQL – Aggregate Functions In general, aggregation is a consideration of a collection of objects that are bound together as a single entity. MySQL provides a set of aggregate functions that perform operations on all the entities of the column of a table considering them as a single unit. Following are the MySQL aggregate functions […]