Technology · Reference dataset
MySQL Advanced Functions
MySQL advanced functions and descriptions of their uses.
Download options
Every record
All 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 |
| 11 | IF | Returns a value if a condition is TRUE, or another value if a condition is FALSE |
| 12 | IFNULL | Return a specified value if the expression is NULL, otherwise return the expression |
| 13 | ISNULL | Returns 1 or 0 depending on whether an expression is NULL |
| 14 | LAST_INSERT_ID | Returns the AUTO_INCREMENT id of the last row that has been inserted or updated in a table |
| 15 | NULLIF | Compares two expressions and returns NULL if they are equal. Otherwise, the first expression is returned |
| 16 | SESSION_USER | Returns the current MySQL user name and host name |
| 17 | SYSTEM_USER | Returns the current MySQL user name and host name |
| 18 | USER | Returns the current MySQL user name and host name |
| 19 | VERSION | Returns the current version of the MySQL database |
Open this data in a free tool: CSV to JSON · JSON formatter · SQL INSERT generator · CSV to XML
CSV / JSON / XML
Put this data to work.
All 19 records are available without a pass, within the free request limits.
- CSV for spreadsheets and lookup tables
- JSON for apps and data analysis
- XML for imports and integrations
Choose your file
Your key is used for this request and is not saved by this page.
Commercial use is allowed, free or paid.
Downloaded a CSV? Convert CSV to JSON, generate SQL inserts, remove duplicate lines, or sort a list with the free tools.
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.