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 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 | 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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-functions/