Posts

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.

How the TIMESTAMPADD() function works in Mariadb?

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

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.

How the NOT-LIKE operator works in Mariadb?

The NOT-LIKE operator is a logical operator that tests whether a string value does not match a specified pattern.

How the TIME_TO_SEC() function works in Mariadb?

The TIME_TO_SEC() function in MariaDB is used to convert a time value into the corresponding number of seconds.

How the JSON_REMOVE() function works in Mariadb?

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

How the NOT IN operator works in Mariadb?

The NOT IN operator is a logical operator that tests whether a value does not match any value in a list of values.

How the TIME_FORMAT() function works in Mariadb?

The TIME_FORMAT() function in MariaDB is used to format a time value according to a specified pattern.

How the JSON_QUOTE() function works in Mariadb?

The JSON_QUOTE() function is a built-in function in Mariadb that allows you to quote a string as a JSON value.

How the TAN() function works in Mariadb?

A complete guide to the TAN() function in MariaDB, including syntax, examples, and related functions.

ow the NOT BETWEEN operator works in Mariadb?

The NOT BETWEEN operator is a logical operator that tests whether a value is outside a specified range.

How the JSON_QUERY() function works in Mariadb?

The JSON_QUERY() function is a built-in function in Mariadb that allows you to extract a JSON document from another JSON document at a given path.

How the NEXTVAL() function works in Mariadb?

The NEXTVAL() function is a sequence function that returns the next value of a sequence.

How the SYSTEM_USER() function works in Mariadb?

How the JSON_PRETTY() function works in Mariadb?

The JSON_PRETTY() function is a built-in function in Mariadb that allows you to add whitespace and indentation to a JSON document, making it more readable and human-friendly.

How the NATURAL_SORT_KEY() function works in Mariadb?

The NATURAL_SORT_KEY() function is a string function that returns a binary string that can be used to sort strings in a natural order.

How the SYSDATE() function works in Mariadb?

The SYSDATE() function in MariaDB is used to retrieve the current date and time from the server’s system clock.

How the JSON_OVERLAPS() function works in Mariadb?

The JSON_OVERLAPS() function is a built-in function in Mariadb that allows you to check whether two JSON documents have any elements in common.

How the NAME_CONST() function works in Mariadb?

The NAME_CONST() function is a utility function that assigns a name to a constant value.

How the SYS_GUID() function works in Mariadb?

The SYS_GUID() function in MariaDB is used to generate a globally unique identifier (GUID) based on a combination of various system values.

How the JSON_OBJECTAGG() function works in Mariadb?

The JSON_OBJECTAGG() function is a built-in function in Mariadb that allows you to create a JSON object from a set of key-value pairs.

How the MAX() function works in Mariadb?

The MAX() function is a useful tool for finding the maximum value in a set of values.

How the MultiPolygonFromWKB() function works in Mariadb?

The MultiPolygonFromWKB() function is a spatial function that converts a well-known binary (WKB) representation of a multipolygon geometry into a multipolygon value.

How the SUM() function works in Mariadb?

The SUM() function in MariaDB is an aggregate function used to calculate the sum of values in a specified column or expression.

How the JSON_OBJECT() function works in Mariadb?

The JSON_OBJECT() function is a built-in function in Mariadb that allows you to create a JSON object from a list of key-value arguments.

How the MASTER_POS_WAIT() function works in Mariadb?

The MASTER_POS_WAIT() function is a useful tool for managing replication in Mariadb.

How the MultiPolygonFromText() function works in Mariadb?

The MultiPolygonFromText() function is a spatial function that converts a well-known text (WKT) representation of a multipolygon geometry into a multipolygon value.

How the SUBTIME() function works in Mariadb?

The SUBTIME() function in MariaDB is used to subtract a time value from a datetime or time value.

How the JSON_OBJECT_TO_ARRAY() function works in Mariadb?

The JSON_OBJECT_TO_ARRAY() function is a built-in function in Mariadb that allows you to convert a JSON object to a JSON array.

How the MASTER_GTID_WAIT() function works in Mariadb?

The MASTER_GTID_WAIT() function is a useful tool for managing replication in Mariadb.

How the MULTIPOLYGON() function works in Mariadb?

The MULTIPOLYGON() function is a spatial function that creates a multipolygon value from a set of polygon values.

How the SUBSTRING() function works in Mariadb?

The SUBSTRING() function in MariaDB is used to extract a substring from a given string, based on the specified starting position and optional length.

How the JSON_OBJECT_FILTER_KEYS() function works in Mariadb?

The JSON_OBJECT_FILTER_KEYS() function is a built-in function in Mariadb that allows you to filter a JSON object by keeping certain keys.

How the MAKETIME() function works in Mariadb?

The MAKETIME() function is a time function that returns a time value that is composed of a given hour, minute, and second.

How the MultiPointFromWKB() function works in Mariadb?

The MultiPointFromWKB() function is a spatial function that converts a well-known binary (WKB) representation of a multipoint geometry into a multipoint value.

How the SUBSTRING_INDEX() function works in Mariadb?

The SUBSTRING_INDEX() function in MariaDB is used to return a substring from a given string, up to a specified delimiter.

How the JSON_MERGE() function works in Mariadb?

The JSON_MERGE() function is a built-in function in Mariadb that allows you to merge two or more JSON documents into one.

How the MAKEDATE() function works in Mariadb?

The MAKEDATE() function is a date function that returns a date value that is composed of a given year and a given day of the year.

How the MultiPointFromText() function works in Mariadb?

The MultiPointFromText() function is a spatial function that creates a multipoint geometry from a well-known text (WKT) representation of the multipoint.

How the SUBSTR() function works in Mariadb?

The SUBSTR() function in MariaDB is used to extract a substring from a given string.

How the JSON_MERGE_PRESERVE() function works in Mariadb?

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