Articles

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

How the MBRContains() function works in Mariadb?

The MBRContains() function is a useful tool for performing spatial queries in Mariadb.

Learn how MariaDB ROW_NUMBER() assigns numbers with PARTITION BY and ORDER BY. See deterministic tie-breaking and a top-N-per-group example.

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

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

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

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

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

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.

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

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