Posts

How the ROW_NUMBER() function works in Mariadb?

The ROW_NUMBER() function is a window function that assigns a sequential integer to each row within a partition of a result set.

How the DAYOFMONTH() function works in Mariadb?

The MariaDB DAYOFMONTH() function is used to extract the day of the month from a given date, returning an integer between 1 and 31.

How the GET_LOCK() function works in Mariadb?

The GET_LOCK() function is a locking function that acquires a named lock with a specified timeout.

How the IS_IPV6() function works in Mariadb?

The IS_IPV6() function is a network function that tests whether a binary value is a valid IPv6 address or not.

How the ROW_COUNT() function works in Mariadb?

The ROW_COUNT() function in MariaDB returns the number of rows affected by the previous statement.

How the DAYNAME() function works in Mariadb?

The DAYNAME() function is a convenient function in Mariadb that returns the name of the weekday for a given date or datetime value.

How the GET_FORMAT() function works in Mariadb?

The GET_FORMAT() function is a date and time function that returns a date or time format string according to a given type and locale.

How the IS_IPV4() function works in Mariadb?

The IS_IPV4() function is a network function that tests whether an IPv6 address is an IPv4 address or not.

How the ROUND() function works in Mariadb?

The ROUND() function in MariaDB is a numeric function that rounds a number to a specified number of decimal places.

How the DAY() function works in Mariadb?

The MariaDB DAY() function is used to extract the day of the month from a given date, returning an integer value between 1 and 31.

How the GeomFromWKB() function works in Mariadb?

The GeomFromWKB() function is a spatial function that creates a geometry object from a well-known binary (WKB) representation.

How the IS_IPV4_MAPPED() function works in Mariadb?

The IS_IPV4_MAPPED() function is a network function that tests whether an IPv6 address is mapped to an IPv4 address or not.

How the RLIKE operator works in Mariadb?

The RLIKE operator in MariaDB is used to test whether a string matches a regular expression.

How the DATEDIFF() function works in Mariadb?

The MariaDB DATEDIFF() function is used to calculate the difference in days between two dates.

How the GeomFromText() function works in Mariadb?

The GeomFromText() function is a spatial function that creates a geometry object from a well-known text (WKT) representation.

How the IS_IPV4_COMPAT() function works in Mariadb?

The IS_IPV4_COMPAT() function is a network function that tests whether an IPv6 address is compatible with an IPv4 address or not.

How the RIGHT() function works in Mariadb?

The RIGHT() function in MariaDB is a string function that returns a given number of characters from the rightmost part of a string.

How the DATE() function works in Mariadb?

The DATE() function is a built-in function in Mariadb that extracts the date part from a date or datetime value and returns it as a date value.

How the GeometryType() function works in Mariadb?

The GeometryType() function is a spatial function that returns the type of a geometry object as a string.

How the IS_FREE_LOCK() function works in Mariadb?

The IS_FREE_LOCK() function is a miscellaneous function that tests whether a named lock is free or not.

How the REVERSE() function works in Mariadb?

The REVERSE() function in MariaDB is a string function that returns the supplied string with all its characters reversed.

How the DATE_SUB() function works in Mariadb?

The DATE_SUB() function is a built-in function in Mariadb that subtracts a specified time interval from a date or datetime value and returns the result as a new date or datetime value.

How the GeometryN() function works in Mariadb?

The GeometryN() function is a spatial function that returns the N-th geometry in a geometry collection.

How the INTERVAL() function works in Mariadb?

The INTERVAL() function is a numeric function that returns the index of the interval that a given value falls into.

How the REPLACE() function works in Mariadb?

How the DATE_FORMAT() function works in Mariadb?

The DATE_FORMAT() function is a built-in function in Mariadb that formats a date or datetime value according to a specified format string and returns the result as a new string value.

How the GeometryFromWKB() function works in Mariadb?

The GeometryFromWKB() function is a spatial function that creates a geometry object from a well-known binary (WKB) representation.

How the INTERSECTS() function works in Mariadb?

The INTERSECTS() function is a spatial function that tests whether two geometries intersect or not.

How the REPEAT() function works in Mariadb?

The REPEAT() function in MariaDB is a string function that returns a string repeated a certain number of times.

How the DATE_ADD() function works in Mariadb?

The DATE_ADD() function is a built-in function in Mariadb that adds a specified time interval to a date or datetime value and returns the result as a new date or datetime value.

How the GeometryFromText() function works in Mariadb?

The GeometryFromText() function is a spatial function that creates a geometry object from a well-known text (WKT) representation.

How the InteriorRingN() function works in Mariadb?

The InteriorRingN() function is a spatial function that returns the N-th interior ring of a polygon.

How the RELEASE_LOCK() function works in Mariadb?

The RELEASE_LOCK() function in MariaDB is used to release a user-level lock that was acquired with the GET_LOCK() function.

How the DATABASE() function works in Mariadb?

The DATABASE() function is a built-in function in Mariadb that returns the name of the current database. This function is often used to get the context of the current session or query.

How the GeometryCollectionFromWKB() function works in Mariadb?

The GeometryCollectionFromWKB() function is a spatial function that creates a geometry collection from a well-known binary (WKB) representation.

How the INSTR() function works in Mariadb?

The INSTR() function is a string function that returns the position of the first occurrence of a substring in a string.

How the CURTIME() function works in Mariadb?

The CURTIME() function is a built-in function in Mariadb that returns the current time as a time value. This function is often used to get the current time of the server or the session.

How the GeometryCollectionFromText() function works in Mariadb?

The GeometryCollectionFromText() function is a spatial function that creates a geometry collection from a well-known text (WKT) representation.

How the INSERT() function works in Mariadb?

The INSERT() function is a string function that replaces a substring of a string with another string.

How the CURRENT_USER() function works in Mariadb?

The CURRENT_USER() function is a built-in function in Mariadb that returns the user name and host name of the current user account.

How the GEOMETRYCOLLECTION() function works in Mariadb?

The MariaDB GEOMETRYCOLLECTION() function is used to create a geometry collection object from a set of individual geometry objects.

How the INET6_NTOA() function works in Mariadb?

The INET6_NTOA() function is a string function that converts a binary value to an IPv6 address in standard notation.

How the CURRENT_TIMESTAMP() function works in Mariadb?

The CURRENT_TIMESTAMP() function is a built-in function in Mariadb that returns the current date and time as a datetime value.

How the GeomCollFromWKB() function works in Mariadb?

The GeomCollFromWKB() function is a spatial function that creates a geometry collection from a well-known binary (WKB) representation.

How the INET6_ATON() function works in Mariadb?

The INET6_ATON() function is a string function that converts an IPv6 address in standard or compressed notation to a binary value.

How the CURRENT_TIME() function works in Mariadb?

The CURRENT_TIME() function is a date and time function that returns the current time as a value in HH:MM:SS format.

How the GeomCollFromText() function works in Mariadb?

The GeomCollFromText() function is a spatial function that creates a geometry collection from a well-known text (WKT) representation.

How the INET_NTOA() function works in Mariadb?

The INET_NTOA() function is a string function that converts a numeric value to an IPv4 address in dotted-quad notation.

How the CURRENT_ROLE() function works in Mariadb?

The MariaDB CURRENT_ROLE() function is used to return the active roles for the current user session.

How the FROM_UNIXTIME() function works in Mariadb?

The FROM_UNIXTIME() function is a date and time function that converts a Unix timestamp to a datetime value.