MariaDB provides many ways to perform date arithmetic. This includes adding or subtracting a certain number of a given date part from a date or datetime value.
In this article, I present 8 ways to add one or more minutes to a datetime value in MariaDB.
Continue readingIn MariaDB, the SCHEMA() function is a synonym for the DATABASE() function. It returns the default (current) database name.
The result is returned as a string in the utf8 character set.
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.
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.
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.
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.
In MariaDB, USER() is a built-in function that returns the current MariaDB user name and host name, given when authenticating to 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 readingIn 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.
This article contains a full list of built-in MariaDB string functions and operators.
Continue reading