MySQL Functions on System Information

Q

Where to find reference information and tutorials on MySQL database functions on System Information? I want to know how to use DATABASE(), VERSION() and other functions.

✍: FYIcenter.com

A

Here is a collection of reference information and tutorials on MySQL database functions on System Information compiled by FYIcenter.com DBA team.

BENCHMARK() - Repeating Expression Evaluation

CONNECTION_ID() - Thread ID of Current Connection

CURRENT_ROLE() - Current Role of Logged-In User

CURRENT_USER() - Authentication Name of Current User

DATABASE() - Name of Current Database

FOUND_ROWS() - Row Count from Last SELECT Statement

ICU_VERSION() - ICU (International Components for Unicode) Version

LAST_INSERT_ID() - Last Value of AUTO_INCREMENT Column

PS_CURRENT_THREAD_ID() - PS Thread ID of Current Connect

PS_THREAD_ID() - PS Thread ID of Given Connect

ROLES_GRAPHML() - User Role Graph in GraphML Format

ROW_COUNT() - Affected Rows from Last DML Statement

SCHEMA() - Synonym for DATABASE()

SESSION_USER() - Synonym for USER()

SYSTEM_USER() - Synonym for USER()

USER() - Login Name of Current User

VERSION() - Version Number of MySQL Server

⇒ BENCHMARK() - Repeating Expression Evaluation

⇐ UUID_TO_BIN() - Converting UUID to Binary

⇑⇑ MySQL Function References

2024-07-15, 1753🔥, 0💬

COERCIBILITY() - Character Collation Coercibility
How to detect the collation coercibility associated to a given character string using the COERCIBILITY() function? COERCIBILITY(str) is a MySQL built-in function that returns the collation coercibility associated to a given character string. A collation coercibility refers to the coercibility index,... 2025-10-14, 3932🔥, 0💬

DATABASE() - Name of Current Database
How to obtain the name of the current database using the DATABASE() function? DATABASE() is a MySQL built-in function that returns the name of the current database. For example: USE mysql; Database changed SELECT DATABASE(); -- +------------+ -- | DATABASE() | -- +------------+ -- | mysql | -- +----... 2025-06-18, 2606🔥, 0💬

CURRENT_USER() - Authentication Name of Current User
How to obtain the authentication name of the current user using the CURRENT_USER() function? CURRENT_USER() is a MySQL built-in function that returns the authentication name of the current user. The authentication name is a combination of "User" and "Host" columns in the mysql.user table and used to... 2025-06-18, 2497🔥, 0💬

CURRENT_ROLE() - Current Role of Logged-In User
How to obtain the current role of the logged-in user using the CURRENT_ROLE() function? CURRENT_ROLE() is a MySQL built-in function that returns the current role of the logged-in user. For example: SELECT CURRENT_ROLE(); -- +----------------+ -- | CURRENT_ROLE() | -- +----------------+ -- | NONE | -... 2024-07-15, 2409🔥, 0💬

MySQL Functions on System Information
Where to find reference information and tutorials on MySQL database functions on System Information? I want to know how to use DATABASE(), VERSION() and other functions. Here is a collection of reference information and tutorials on MySQL database functions on System Information compiled by FYIcente... 2024-07-15, 1754🔥, 0💬

CRC32() - Cyclic Redundancy Check 32-Bit
How to calculate the 32-bit CRC (Cyclic Redundancy Check) value using the CRC32() function? CRC32(str) is a MySQL built-in function that calculates the 32-bit CRC (Cyclic Redundancy Check) value of a given character string and returns it as an integer. For example: SELECT CRC32('MySQL'), HEX(CRC32('... 2024-07-15, 1711🔥, 0💬

COLLATION() - Detecting Character Collation Name
How to detect the character collation name associated to a given character string using the COLLATION() function? COLLATION(str) is a MySQL built-in function that returns the character collation name associated to a given character string. A character collation name refers to a set of rules to sort ... 2025-10-14, 1685🔥, 0💬

BENCHMARK() - Repeating Expression Evaluation
How to evaluate an expression repeatedly for benchmark testing using the BENCHMARK() function? BENCHMARK(count, exp) is a MySQL built-in function that evaluates an expression repeatedly for benchmark testing and returns 0. For example: SELECT BENCHMARK(1000000, AES_ENCRYPT('hello','goodbye') );-- +-... 2024-07-17, 1580🔥, 2💬

💬 2024-07-17 Iqra Technology: This is a great overview of the `BENCHMARK()` function in MySQL! Your examples clearly illustrate how it can be used to evaluate...

FORMAT_PICO_TIME() - Formatting Picoseconds in Readable Units
How to format a number of picoseconds in a human-readable unit using the FORMAT_PICO_TIME() function? FORMAT_PICO_TIME(con) is a MySQL built-in function that converts a number of picoseconds in a human-readable unit of ps, ns, ms, s, min, h, or d. For example: SELECT FORMAT_PICO_TIME(9), FORMAT_PICO... 2025-09-24, 1525🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.