SQL – MySQL BINARY Function
The MySQL BINARY function converts a value to a binary string.
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.
SQL – MySQL CONNECTION_ID() Function
The MySQL CONNECTION_ID() function returns the unique connection ID for the current connection.
SQL – MySQL CONV() Function
The MySQL CONV() function converts a number from one numeric base system to another, and returns the result as a string value.
SQL – MySQL CONVERT() Function
The MySQL CONVERT() function converts a value into the specified datatype or character set.
SQL – MySQL COUNT() Function
The MySQL COUNT() function returns the number of records returned by a select query. NULL values are not counted.
SQL – MySQL CURDATE() Function
The MySQL CURDATE() function returns the current date as “YYYY-MM-DD” (string) or as YYYYMMDD (numeric).
SQL – MySQL CURRENT_DATE() Function
The MySQL CURRENT_DATE() function returns the current date as “YYYY-MM-DD” (string) or as YYYYMMDD (numeric).
SQL – MySQL CURRENT_TIME() Function
The MySQL CURRENT_TIME() function returns the current time as “HH-MM-SS” (string) or as HHMMSS.uuuuuu (numeric).
SQL – MySQL CURRENT_TIMESTAMP() Function
The MySQL CURRENT_TIMESTAMP() function returns the current date and time as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).