Information Functions

General information functions, including BENCHMARK, CHARSET, DATABASE, USER, VERSION, etc.

Title Description
BENCHMARK Executes an expression repeatedly.
BINLOG_GTID_POS Returns a string representation of the corresponding GTID position.
CHARSET Returns the character set.
COERCIBILITY Returns the collation coercibility value.
COLLATION Collation of the string argument.
CONNECTION_ID Connection thread ID.
CURRENT_ROLE Current role name.
CURRENT_USER Username/host that authenicated the current client.
DATABASE Current default database.
DECODE_HISTOGRAM Returns comma separated numerics corresponding to a probability distribution.
DEFAULT Returns column default.
FOUND_ROWS Number of (potentially) returned rows.
LAST_INSERT_ID Last inserted auto_increment value.
LAST_VALUE Returns the last value in a list or set of values.
PROCEDURE ANALYSE Suggests optimal data types for each column.
ROW_COUNT Number of rows affected by previous statement.
SCHEMA Synonym for DATABASE().
SESSION_USER Synonym for USER().
SYSTEM_USER Synonym for USER().
USER Current user/host.
VERSION MariaDB server version.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.