SECOND() Function in MySQL

MySQL | SESSION_USER( ) Function

Last Updated : 25 Nov, 2019

The MySQL SESSION_USER() function is used for returning the current user name and host name for the MySQL connection being used by the user. The SESSION_USER() function does not require any parameter to be passed.

The user name returned by the SESSION_USER() function is the name of the user-specified when connecting to the server whereas the host name returned by the SESSION_USER() function is the name of the client host that the user uses to establish a connection from.

Syntax:

SESSION_USER()

Parameters Used:
It does not require any parameter or argument to be passed.

Return Value:
The MySQL SESSION_USER() function returns the current user name and host name for the MySQL connection.

Supported Versions of MySQL

MySQL 5.7
MySQL 5.6
MySQL 5.5
MySQL 5.1
MySQL 5.0
MySQL 4.1
MySQL 4.0
MySQL 3.23

Example: Implementing SESSION_USER() function in MySQL.

SELECT SESSION_USER();

Output:

author@gfg

SECOND() Function in MySQL

S

Shubrodeep Banerjee

Improve

Article Tags :

Similar Reads

MySQL | USER( ) Function

The USER() function in MySQL is a useful tool for retrieving information about the current database connection. It provides details about the user name and the hostname from which the connection was established. In this article, we will explore MySQL USER() Function by understanding how USER() opera

MySQL | VERSION( ) Function

The MySQL Version() function is used for returning the current version of the MySQL database. This function uses the utf8 character set. Generally, there is a suffix returned after the version number. The Version() function does not require any parameter to be passed. Syntax: VERSION() Parameters Us

SYSTEM_USER() Function in MySQL

SYSTEM_USER() : This function helps to return the name of the user and hostname for the current MySQL user. And the SYSTEM_USER() function doesn't require any parameter to be passed. The username which will be returned is the name of the user-specified when connecting to the server. And the hostname

MySQL | PASSWORD Function

The MySQL PASSWORD function is used for the generation of a hashed password using a plain-text password string It uses hashing techniques to generate the hashed password. This function is carried out by the authentication system. MySQL server uses the PASSWORD function to encrypt MySQL passwords for

SECOND() Function in MySQL

SECOND() function in MySQL is used to return the second portion of a specified time or date-time value. The first parameter in this function will be the date/Date Time. This function returns the seconds from the given date value. The return value (seconds) will be in the range of 0 to 59. In this fu

SESSION_USER() Function in SQL Server

SESSION_USER() : This function in SQL Server is used to return the current user's name in the database of SQL Server that is in use. Features : This function is used to find the current user's name.This function comes under Advanced Functions.This function doesn't accept any parameter. Syntax : SESS

SIGN() Function in MySQL

SIGN() function in MySQL is used to return the sign of the given number. It returns 1 if the number is positive, -1 if the number is negative and 0 for zero. Syntax : SIGN(X) Parameter : SIGN() function accepts one parameter as input and will give you the results in values like Positive(+1),Negative

PLSQL | REMAINDER Function

The REMAINDER function is an inbuilt function in PLSQL which is used to return the remainder of a divided by b. Syntax: REMAINDER(a, b) Parameters Used: This function accepts two parameters a and b which is used in calculating the remainder when a is divided by b. Return Value: This function returns

MySQL | NULLIF( ) Function

The MySQL NULLIF() function is used for the comparison of two expressions. The NULLIF() function returns NULL if both the expressions are equal, else it returns the first expression. The NULLIF() function accepts the expressions as parameter and returns NULL if both of them are equal. Syntax: NULLIF

MySQL | OLD_PASSWORD Function

The MySQL OLD_PASSWORD function is used for generating a hashed password from a plaintext password string. The OLD_PASSWORD function uses hashing techniques to perform the generation of the hashed password. This function is carried out by the authentication system. This function is used by the MySQL