system functions

In MySQL, CURRENT_ROLE() is a built-in function that returns the current active roles for the current session, separated by commas, or NONE if there are none. The current role determines our access privileges.

Read more

In MySQL, the COERCIBILITY() returns the collation coercibility value of its string argument.

The COERCIBILITY() function defines how collations will be converted in the case of collation conflict. In such conflicts, an expression with a higher coercibility is converted to the collation of an expression with a lower coercibility.

Read more

The MySQL CONNECTION_ID() function returns the connection ID (thread ID) for the connection.

In MySQL, every connection has an ID that is unique among the set of currently connected clients. We can use the CONNECTION_ID() function to return that ID.

Read more

In MySQL, VERSION() is a built-in function that returns the MySQL server version.

The result is a string that uses the utf8mb3 character set. A suffix may also be appended to the version number indicating server build or configuration information.

Read more

In MySQL, SESSION_USER() is a synonym for the USER() function. It returns the current MySQL user name and host name, given when connecting to MySQL.

Read more

In MySQL, SYSTEM_USER() is a synonym for the USER() function. It returns the current MySQL user name and host name, given when connecting to MySQL.

Read more

In MySQL, CURRENT_USER() is a built-in function that returns the user name and host name combination for the MySQL account that the server used to authenticate the current client.

Read more

In MySQL, USER() is a built-in function that returns the current MySQL user name and host name, given when connecting to MySQL.

The result is returned as a string in the utf8mb3 character set.

The value returned by USER() could be different to the value returned by CURRENT_USER().

Read more