Articles

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

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.

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

See which MariaDB account CURRENT_USER() returns, compare it with USER(), and understand its DEFINER behavior in stored procedures.

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

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

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

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

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

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

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