In MariaDB, SESSION_USER() is a synonym for the USER() function. It returns the current MariaDB user name and host name, given when authenticating to MariaDB.
Tag: functions
MariaDB CURRENT_USER() Explained
In MariaDB, CURRENT_USER() is a built-in function that returns the user name and host name combination for the MariaDB account that the server used to authenticate the current client.
MariaDB USER() Explained
In MariaDB, USER() is a built-in function that returns the current MariaDB user name and host name, given when authenticating to MariaDB.
MariaDB CONNECTION_ID() Explained
In MariaDB, every thread (including each event) has an ID that is unique among the set of currently connected clients. The CONNECTION_ID() function is a built-in function that returns the connection ID (thread ID) for the connection.
MariaDB BENCHMARK() Explained
In MariaDB, BENCHMARK() is a built-in function that executes an expression a specified number of times.
It can be used to time how quickly MariaDB processes the expression.
The result is always 0. The function is intended to be used within the mysql command line tool, which reports query execution times.
MariaDB Date & Time Functions (Full List)
This article contains a full list of built-in MariaDB date and time functions.
Continue readingDifference Between TRIM() and TRIM_ORACLE() in MariaDB
MariaDB has a TRIM() function and a TRIM_ORACLE() function. Both functions do essentially the same thing. But there is a minor difference.
How SLEEP() Works in MariaDB
In MariaDB, SLEEP() is a built-in function that sleeps (pauses) for the number of seconds specified by its argument.
If uninterrupted, it returns 0, if interrupted, it returns 1.
How OCT() Works in MariaDB
In MariaDB, OCT() is a built-in function that returns a string representation of the octal value of its argument.
How TAN() Works in MariaDB
In MariaDB, TAN() is a built-in numeric function that returns the tangent of its argument.