Posts

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.

How the MAKE_SET() function works in Mariadb?

The MAKE_SET() function is a string function that returns a set of strings that are selected from a list of strings based on a given bit mask.

How the MULTIPOINT() function works in Mariadb?

The MULTIPOINT() function is a spatial function that creates a geometry collection of points from a set of coordinates or point geometries.

How the SUBDATE() function works in Mariadb?

The SUBDATE() function in MariaDB is used to subtract a specified time interval from a given date or datetime value.

How the JSON_MERGE_PATCH() function works in Mariadb?

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

How the LTRIM() function works in Mariadb?

The LTRIM() function is a string function that returns a string that is left-trimmed of any leading spaces.

How the MultiLineStringFromWKB() function works in Mariadb?

The MultiLineStringFromWKB() function is a spatial function that creates a MULTILINESTRING object from a Well-Known Binary (WKB) representation.

How the STRCMP() function works in Mariadb?

he STRCMP() function in MariaDB is used to compare two strings lexically (based on their character values).

How the JSON_LOOSE() function works in Mariadb?

In this article, we will introduce the JSON_LOOSE() function in Mariadb, which is a built-in function that adds spaces to a JSON document to make it more readable.

How the LPAD() function works in Mariadb?

The LPAD() function is a string function that returns a string that is left-padded with a specified character to a certain length.

How the MultiLineStringFromText() function works in Mariadb?

The MultiLineStringFromText() function is a spatial function that creates a MULTILINESTRING object from a text representation.

How the STR_TO_DATE() function works in Mariadb?

The STR_TO_DATE() function in MariaDB is used to parse a string representation of a date and time and convert it into a DATE or DATETIME value.

How the JSON_LENGTH() function works in Mariadb?

The JSON_LENGTH() function is a JSON function that returns the length of a JSON document.

How the LOWER() function works in Mariadb?

The LOWER() function is a string function that returns a string with all the characters converted to lowercase.

How the MULTILINESTRING() function works in Mariadb?

The MULTILINESTRING() function is a spatial function that creates a MULTILINESTRING object from a list of line strings.

How the STDDEV() function works in Mariadb?

The STDDEV() function, short for standard deviation, is a statistical measure used in MariaDB to quantify the amount of variation or dispersion in a set of values.

How the JSON_KEYS() function works in Mariadb?

The JSON_KEYS() function is a JSON function that returns the keys of a JSON object.

How the LOG10() function works in Mariadb?

The LOG10() function is a mathematical function that returns the logarithm of a number to the base 10.

How the MPolyFromWKB() function works in Mariadb?

The MPolyFromWKB() function is a spatial function that creates a MULTIPOLYGON object from a Well-Known Binary (WKB) representation.

How the STDDEV_SAMP() function works in Mariadb?

The STDDEV_SAMP() function in MariaDB is a statistical function that calculates the sample standard deviation of a set of values.

How the JSON_INSERT() function works in Mariadb?

The JSON_INSERT() function is a JSON function that inserts a value or values into a JSON document at a given path or paths.

How the LOG2() function works in Mariadb?

The LOG2() function is a mathematical function that returns the logarithm of a number to the base 2.

How the MPolyFromText() function works in Mariadb?

The MPolyFromText() function is a spatial function that returns a multipolygon geometry value from a well-known text (WKT) representation.

How the STDDEV_POP() function works in Mariadb?

The STDDEV_POP() function is a statistical aggregate function in MariaDB that computes the population standard deviation of a set of values.

How the JSON_EXTRACT() function works in Mariadb?

The JSON_EXTRACT() function is a JSON function that extracts a value or values from a JSON document at a given path or paths.

How the LOG() function works in Mariadb?

The LOG() function is a mathematical function that returns the natural logarithm of a number.

How the MPointFromWKB() function works in Mariadb?

The MPointFromWKB() function is a spatial function that returns a multipoint geometry value from a well-known binary (WKB) representation.