Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

SYSTEM_USER

Example

Retrieve the current username and host details for the MySQL connection.

SELECT SYSTEM_USER();

Definition and Usage

The SYSTEM_USER() function retrieves the current username and host name for the MySQL connection.

Note: This function is equivalent to SESSION_USER() and USER().

Syntax

SYSTEM_USER()

Technical Details

Works in:

 From MySQL version 4.0