bugl
bugl
HomeLearnPatternsPathsSearch
HomeLearnPatternsPathsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MySQL USER() Function

Flash cards

Review the key moves

1/4
Core idea

What is the main idea behind MySQL USER() Function?

Lesson checks

Practice each idea before moving on

Short Mimo-style checks built from this lesson's code, terms, and sequence.

1Quick choice

Which statement best captures the main point of this lesson?

2Fill blank

Complete the missing token from the example code.

___ USER();
3Order

Put the learning moves in the order that makes the concept easiest to apply.

The USER() function returns the current user name and host name for the MySQL connection.
Definition and Usage
MySQL USER() Function

Example

SELECT USER();

Definition and Usage

The USER() function returns the current user name and host name for the MySQL connection.

Note

This function is equal to the SESSION_USER() function and the SYSTEM_USER() function.

Tip

Also look at the CURRENT_USER() function.

Syntax

USER()

Technical Details

Works in:From MySQL 4.0

Previous

MySQL SYSTEM_USER() Function

Next

MySQL VERSION() Function