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).
SQL – MySQL CURRENT_USER() Function
The MySQL CURRENT_USER() function returns the user name and host name for the MySQL account that the server used to authenticate the current client.
SQL – MySQL CURTIME() Function
The MySQL CURTIME() function returns the current time as “HH-MM-SS” (string) or as HHMMSS.uuuuuu (numeric).
SQL – MySQL DATABASE() Function
The MySQL DATABASE() function returns the name of the current database. If there is no current database, this function returns NULL or “”.