Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How the SCHEMA() function works in Mariadb?

The SCHEMA() function in MariaDB is used to retrieve the name of the current database schema or database from which it is being called.

How the IS-NULL operator works in Mariadb?

The MariaDB IS NULL operator is used to check if a value in a column or expression is NULL.

How the LAST_INSERT_ID() function works in Mariadb?

The LAST_INSERT_ID() function is a information function that returns the value of the AUTO_INCREMENT column for the last row that was inserted or updated by the current session.

How the MBREqual() function works in Mariadb?

The MBREqual() function is a useful tool for performing spatial queries in Mariadb.

How the RTRIM() function works in Mariadb?

The RTRIM() function is a string function that removes all trailing spaces from a string.

How the IS NOT NULL operator works in Mariadb?

The MariaDB IS NOT NULL operator is used to check if a value in a column or expression is not NULL.

How the LAST_DAY() function works in Mariadb?

The LAST_DAY() function is a date and time function that returns the last day of the month for a given date.

How the MBRDisjoint() function works in Mariadb?

The MBRDisjoint() function is a useful tool for performing spatial queries in Mariadb.

How the RPAD() function works in Mariadb?

The RPAD() function in MariaDB is a string function that pads the right side of a string with a specified number of a specified character.

How the IS_USED_LOCK() function works in Mariadb?

In this article, we will introduce the IS_USED_LOCK() function in Mariadb, which is a locking function that checks whether a named user-level lock is in use or not.