MySQL – NULL Values Table of content The MySQL NULL Values MySQL uses the term “NULL” to represent a non-existent data value in the database. These values are different from an empty string or zero and do not occupy any storage space in the database. They are used to indicate the absence of a value […]

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 […]

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 […]