Information Functions
General information functions, including BENCHMARK, CHARSET, DATABASE, USER, VERSION, etc.
-
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 ID. -
CURRENT_ROLE
Current role name. -
CURRENT_USER
Username/host that authenticated 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. -
ROWNUM
Function that returns the number of accepted rows so far. -
ROW_COUNT
Number of rows affected by previous statement. -
SCHEMA
Synonym for DATABASE(). -
SESSION_USER
Prior to MariaDB 11.7, 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.
