In MariaDB, SYSTEM_USER() is a synonym for the USER() function. It returns the current MariaDB user name and host name, given when authenticating to MariaDB.
Tag: what is
MariaDB SESSION_USER() Explained
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.
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.
Database Relationships Explained
If you’re new to relational databases, and you’re trying to get your head around this concept of a “relationship” in your database, I hope this article helps.
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.