MySafeInfo

MySQL Advanced Functions

Technology 19 records updated 2026-07-17

MySQL Advanced Functions, with function, and description.

Get this data

GET https://mysafeinfo.com/api/data/mysqladvancedfunctions

JSON XML CSV Download CSV

Sort, page, randomize, and download with query parameters; see the documentation.

Try it live

Run a request against mysqladvancedfunctions straight from your browser. Add your API key to lift the row cap and return every record. The call goes to the API and nothing is stored here.

Preview

First 19 of 19 records. Click a column to sort these rows.

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

Notes