In MariaDB, JSON_TABLE() is a built-in function that converts JSON data into a relational form.
In other words, it lets you return a JSON document as a table.
The JSON_TABLE() function was introduced in MariaDB 10.6.0.
Category: MariaDB
MariaDB LTRIM() vs LTRIM_ORACLE(): What’s the Difference?
MariaDB has an LTRIM() function and a LTRIM_ORACLE() function. Both functions do essentially the same thing. But there is a minor difference.
MariaDB DEFAULT() Explained
In MariaDB, DEFAULT() is a built-in function that returns the default value for a table column.
If the column has no default value and it is nullable, then NULL is returned. If the column has no default value and it is not nullable, an error is returned.
4 Functions that Return the Seconds Part from a Time Value in MariaDB
Below are 4 functions that enable you to return the seconds part from a time value in MariaDB.
Continue readingMariaDB ROWNUM() Explained
In MariaDB, ROWNUM() is a built-in function that returns the current number of accepted rows in the current context. Its main purpose is to emulate the ROWNUM pseudo column in Oracle.
ROWNUM() can be used in a way that has a similar effect to the LIMIT clause – to limit the number of results returned by a query.
When in Oracle mode, it can be called as ROWNUM (i.e. without the parentheses).
The ROWNUM() function is supported from MariaDB 10.6.1.
MariaDB VERSION() Explained
In MariaDB, VERSION() is a built-in function that returns the MariaDB server version.
The result is a string that uses the utf8 character set.
MariaDB FOUND_ROWS() Explained
In MariaDB, you can use the LIMIT clause to reduce the number of rows returned by a query. The FOUND_ROWS() function can be used in such queries to return the number of rows that would have been returned, had the LIMIT clause not been included.
This can be handy, because it allows you to get this information without having to run the query again.
The FOUND_ROWS() function can also be used to return the number of rows that were actually returned by the limited statement, if that’s what you need.
8 Ways to Add Minutes to a Datetime in MariaDB
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 readingMariaDB SCHEMA() Explained
In 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.
MariaDB DATABASE() Explained
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.