SQL – MySQL ABS() Function
The MySQL ABS() function returns the absolute value of a number.
SQL – MySQL ACOS() Function
The MySQL ACOS() function returns the arc cosine of a number. The specified number must be between -1 and 1, or NULL will be returned.
SQL – MySQL ADDDATE() Function
The MySQL ADDDATE() function adds a time/date interval to a date and then returns the date.
SQL – MySQL ADDTIME() Function
The MySQL ADDTIME() function adds a time interval to a time/datetime and then returns the time/datetime.
SQL – MySQL ASCII() Function
The MySQL ASCII() function returns the ASCII value for the specific character.
SQL – MySQL ASIN() Function
The MySQL ASIN() function returns the arc sine of a number. The specified number must be between -1 and 1, or NULL will be returned.
SQL – MySQL ATAN() Function
The MySQL ATAN() function returns the arc tangent of one or two numbers.
SQL – MySQL AVG() Function
The MySQL AVG() function returns the average value of an expression (NULL values are ignored).
SQL – MySQL BIN() Function
The MySQL BIN() function returns a binary representation of a number, as a string value.
SQL – MySQL CASE Function
The MySQL CASE statement goes through conditions and will stop reading and return a value when the first condition in the list is met.
SQL – MySQL CAST() Function
The MySQL CAST() function converts a value of any type into the specified datatype.
SQL – MySQL CEIL() Function
The MySQL CEIL() function returns the smallest integer value that is bigger than or equal to a number.
SQL – MySQL CEILING() Function
The MySQL CEILING() function returns the smallest integer value that is bigger than or equal to a number.
SQL – MySQL CHAR_LENGTH() Function
The MySQL CHAR_LENGTH() function returns the length of a string in characters.
SQL – MySQL CHARACTER_LENGTH() Function
The MySQL CHARACTER_LENGTH() function returns the length of a string in characters.
SQL – MySQL COALESCE() Function
The MySQL COALESCE() function returns the first non-null value in a list.
SQL – MySQL CONCAT_WS() Function
The MySQL CONCAT_WS() function adds two or more expressions together using a separator.