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.
what is
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.
Difference 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.
How SQRT() Works in MariaDB
In MariaDB, ASIN() is a built-in numeric function that returns the square root of its argument.
How TO_CHAR() Works in MariaDB
In MariaDB, TO_CHAR() is a built-in string function that converts a date/time expression to a string.
The expression can be a date, datetime, time, or timestamp value.
This function was introduced in MariaDB 10.6.1 to enhance Oracle compatibility.
How SIGN() Works in MariaDB
In MariaDB, SIGN() is a built-in function that returns the sign of its argument as -1, 0, or 1, depending on whether the argument is negative, zero, or positive.