Menu

Articles

How the JSON_SET() function works in Mariadb?

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.

How the NTILE() function works in Mariadb?

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

How the TIMESTAMP() function works in Mariadb?

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

How the JSON_SEARCH() function works in Mariadb?

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

How the NOW() function works in Mariadb?

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

How the TIMEDIFF() function works in Mariadb?

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

How the JSON_SCHEMA_VALID() function works in Mariadb?

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

How the NOT REGEXP operator works in Mariadb?

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

How the TIME-function() function works in Mariadb?

The TIME() function in MariaDB is used to extract the time portion from a datetime or time expression.

How the JSON_REPLACE() function works in Mariadb?

The JSON_REPLACE() function is a built-in function in Mariadb that allows you to replace one or more elements in a JSON document at a given path.