Collections:
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.
✍: FYIcenter.com
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()
⇒ BENCHMARK() - Repeating Expression Evaluation
2023-12-19, 244🔥, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...