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 […]
Category Archives: mysql
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 – Sequences Table of content A sequence is a series of integers, starting from 1 and incrementing by 1 with each successive value. These sequences are usually used in databases, as many applications require each row in a table to have a unique identifier, and sequences provide an easy way to generate such values. […]