Learn SQL and Database by Examples

SQLiz.com provides database-related articles, tutorials to help you learn SQL and Databases. You can find MySQL, PostgreSQL, Oracle, SQL Server, SQLite, Mongo, Redis tutorials here.

All tutorials on the site come with practical examples. Hope to help you learn SQL and databases faster.

How the RPAD() function works in Mariadb?

The RPAD() function in MariaDB is a string function that pads the right side of a string with a specified number of a specified character.

How the MBRDisjoint() function works in Mariadb?

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

How the LAST_DAY() function works in Mariadb?

The LAST_DAY() function is a date and time function that returns the last day of the month for a given date.

How the IS-NOT-NULL operator works in Mariadb?

The IS-NOT-NULL operator is a logical operator that tests whether a value or expression is not NULL.

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 MBRContains() function works in Mariadb?

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

How the KDF() function works in Mariadb?

The KDF() function is a cryptographic function that derives a key from a password and a salt.

How the IS_USED_LOCK() function works in Mariadb?

In this article, we will introduce the IS_USED_LOCK() function in Mariadb, which is a locking function that checks whether a named user-level lock is in use 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 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 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 DAYOFMONTH() function works in Mariadb?

The DAYOFMONTH() function is a synonym for the DAY() function in Mariadb that returns the day of the month for a given date or datetime value.

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 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 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 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 RLIKE operator works in Mariadb?

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

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 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 DAY() function works in Mariadb?

The DAY() function is a simple but useful function in Mariadb that returns the day of the month for a given date or datetime value.

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 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 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 DATEDIFF() function works in Mariadb?

The DATEDIFF() function is a useful function in Mariadb that returns the difference in days between two date or datetime values.

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 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 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 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 REPLACE() function works in Mariadb?

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.