In MariaDB, DATABASE() is a built-in function that returns the default (current) database name.
The result is returned as a string in the utf8 character set.
Author: Ian
MariaDB SYSTEM_USER() Explained
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.
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.
4 Functions to Return the Year from a Date in MariaDB
Below are 4 functions that enable you to return the year from a date in MariaDB. Three functions return just the year, and one returns both the year and week.
Continue readingMariaDB 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 String Functions (Full List)
This article contains a full list of built-in MariaDB string functions and operators.
Continue readingMariaDB 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.
How to Run SHOW LOCALES in MariaDB
If you’re trying to run SHOW LOCALES but it’s not working, it’s probably because the LOCALES plugin hasn’t been installed yet. Installing that plugin should hopefully fix the problem.