Aggregate Functions
Aggregate Functions SQL aggregate functions return a single value, calculated from values in a column. Useful aggregate functions: Function Description AVG() Returns the average value COUNT() [...]
Information Functions
Information Functions CONNECTION_ID() Returns the connection ID (thread ID) for the connection. Every connection has an ID that is unique among the set of currently connected clients. [...]
Date and Time Functions
Date and Time Functions CURDATE(),CURRENT_DATE, CURRENT_DATE() Returns the current date as a value in ‘YYYY-MM-DD’ or YYYYMMDD format, depending on whether the function is used in a [...]
String Functions
MySQL String functions UPPER(), UCASE() Returns the string with all characters changed to uppercase. LOWER(), LCASE() Returns the string with all characters changed to lowercase. CHAR_LENGTH(str) [...]