MySQL Advanced Functions
MySQL advanced functions and descriptions of their uses.
Download optionsThe records
10 of 19 records · Select a column heading to sort.
| ID | Function | Description |
|---|---|---|
| 1 | BIN | Returns a binary representation of a number |
| 2 | BINARY | Converts a value to a binary string |
| 3 | CASE | Goes through conditions and return a value when the first condition is met |
| 4 | CAST | Converts a value (of any type) into a specified datatype |
| 5 | COALESCE | Returns the first non-null value in a list |
| 6 | CONNECTION_ID | Returns the unique connection ID for the current connection |
| 7 | CONV | Converts a number from one numeric base system to another |
| 8 | CONVERT | Converts a value into the specified datatype or character set |
| 9 | CURRENT_USER | Returns the user name and host name for the MySQL account that the server used to authenticate the current client |
| 10 | DATABASE | Returns the name of the current database |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last checked against sources: October 15, 2026.
Last changed: July 17, 2026. This is when we last changed the data or its description. It doesn’t mean the data runs up to that date.
A complete download includes all 19 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/mysqladvancedfunctionsChoose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.
Without a pass, sorting and randomization apply only to the fixed 10-row sample.