SESSION_USER()

SESSION_USER() is a synonym for USER().

Syntax

MYSQL Copy

CREATE TABLE t (c VARCHAR(288) DEFAULT (SESSION_USER()));

Examples

Example

Like USER(), this function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE TABLE statement:

MYSQL Copy

CREATE TABLE t (c VARCHAR(288) DEFAULT (SESSION_USER()));