Articles

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

How the NULLIF() function works in Mariadb?

The NULLIF() function is a useful function in Mariadb that returns NULL if two expressions are equal, or the first expression if they are not.

The TIMESTAMPADD() function in MariaDB is used to add an interval to a date or datetime expression.

The JSON_SET() function is a JSON function that inserts or updates data in a JSON document and returns the result as a JSON document.

The NTILE() function is a window function that divides a result set into a specified number of groups of approximately equal size.

The TIMESTAMP() function in MariaDB is used to convert a date or datetime expression into a DATETIME value.

The JSON_MERGE() function is a JSON function that merges two or more JSON documents and returns the result as a JSON document.

The NOW() function is a date and time function that returns the current date and time.

The TIMEDIFF() function in MariaDB is used to calculate the difference between two time or date-time expressions.

The JSON_SCHEMA_VALID() function is a built-in function in Mariadb that allows you to validate a JSON document against a JSON schema.

The NOT REGEXP operator is a logical operator that tests whether a string value does not match a regular expression.