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, 776🔥, 0💬

ICU_VERSION() - ICU (International Components for Unicode) Version
How to obtain the version number of the ICU (International Components for Unicode) library using the ICU_VERSION() function? ICU_VERSION() is a MySQL built-in function that returns the version number of the ICU (International Components for Unicode) library. For example: SELECT ICU_VERSION(); -- +--... 2025-04-11, 880🔥, 0💬

FOUND_ROWS() - Row Count from Last SELECT Statement
How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function? FOUND_ROWS() is a MySQL built-in function that returns the number of rows found by the last SELECT statement. For example: SELECT help_topic_id, name FROM mysql.help_topic; -- +---------------+------... 2025-04-11, 867🔥, 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, 819🔥, 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, 777🔥, 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, 750🔥, 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...

LEAST() - Finding the Least/Minimum Value
How to find the least (minimum) value of a given list of values using the LEAST() function? LEAST(val1, val2, ...) is a MySQL built-in function that returns the least (minimum) value of a given list of values. For example: SELECT LEAST(70, 89, 73, 99, 101, 110, 116, 101, 114); -- +------------------... 2023-12-19, 738🔥, 0💬

SLEEP() - Holding Statement Execution
How to hold the statement execution for some time using the SLEEP() function? SLEEP(sec) is a MySQL built-in function that holds the execution of the current statement for sec seconds. For example: SELECT SYSDATE(), SLEEP(2), SYSDATE(); -- +---------------------+------- ---+---------------------+-- ... 2023-12-19, 674🔥, 0💬

CONNECTION_ID() - Thread ID of Current Connection
How to obtain the connection ID of the current connection using the CONNECTION_ID() function? CONNECTION_ID() is a MySQL built-in function that returns the connection ID of the current connection. The connection ID is also referred as thread ID or process ID. For example: SELECT CONNECTION_ID(); -- ... 2024-07-15, 649🔥, 0💬

NULLIF() - NULL on Equal Values
How to generate NULL with equal values using the NULLIF() function? NULLIF(val1, val2) is a MySQL built-in function that returns NULL if the first argument equals the second, the first argument otherwise. For example: SELECT NULLIF('yes', 'yes'), NULLIF('yes', 'no'); -- +----------------------+-----. .. 2023-12-19, 649🔥, 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.