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, 250🔥, 0💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...