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

The PolyFromWKB() function is a spatial function in Mariadb that creates a Polygon object from a well-known binary (WKB) representation.

How the OLD_PASSWORD() function works in Mariadb?

The OLD_PASSWORD() function is a built-in function in Mariadb that returns the hashed password of a string value using the pre-4.1 hashing algorithm.

How the TO_SECONDS() function works in Mariadb?

The TO_SECONDS() function in MariaDB is used to convert a time or datetime value into the corresponding number of seconds.

How the PolyFromText() function works in Mariadb?

The PolyFromText() function is a spatial function in Mariadb that creates a Polygon object from a well-known text (WKT) representation.

How the OCTET_LENGTH() function works in Mariadb?

The OCTET_LENGTH() function is a built-in function in Mariadb that returns the number of bytes in a string value.

How the TO_DAYS() function works in Mariadb?

The TO_DAYS() function in MariaDB is used to convert a date or datetime value into the corresponding day number.

How the OCT() function works in Mariadb?

The OCT() function is a built-in function in Mariadb that returns the octal representation of a decimal or string value.

How the JSON_VALUE() function works in Mariadb?

The JSON_VALUE() function is a useful tool for extracting scalar values from JSON documents in Mariadb.

How the TO_CHAR() function works in Mariadb?

The TO_CHAR() function in MariaDB is used to convert a date, datetime, time or timestamp value into a string representation.

How the NumPoints() function works in Mariadb?

The NumPoints() function is a spatial function in Mariadb that returns the number of points in a linestring, or 0 if the argument is not a linestring.

How the JSON_VALID() function works in Mariadb?

The JSON_VALID() function is a simple but useful function for validating whether a JSON value is well-formed and valid.

How the TO_BASE64() function works in Mariadb?

The TO_BASE64() function in MariaDB is used to convert a string or binary value into its Base64 encoded representation.

How the NumInteriorRings() function works in Mariadb?

The NumInteriorRings() function is a spatial function in Mariadb that returns the number of interior rings in a polygon, or 0 if the argument is not a polygon.

How the JSON_UNQUOTE() function works in Mariadb?

The JSON_UNQUOTE() function is a simple but useful function for removing the double quotes from a JSON value.

How the TIMESTAMPDIFF() function works in Mariadb?

The TIMESTAMPDIFF() function in MariaDB is used to calculate the difference between two date or datetime expressions.

How the NumGeometries() function works in Mariadb?

The NumGeometries() function is a spatial function in Mariadb that returns the number of geometries in a geometry collection, or 1 if the argument is not a geometry collection.

How the JSON_TYPE() function works in Mariadb?

The JSON_TYPE() function is a simple but useful function for inspecting the type of a JSON value.

How the TIMESTAMPADD() function works in Mariadb?

The TIMESTAMPADD() function in MariaDB is used to add an interval to a date or datetime expression.

How the NULLIF() function works in Mariadb?

The NULLIF() function is a useful function in Mariadb that returns NULL if two expressions are equal, or the first expression if they are not.

How the JSON_TABLE() function works in Mariadb?

The JSON_TABLE() function is a powerful and versatile tool for extracting data from JSON documents and converting them into tabular format.

How the TIMESTAMP() function works in Mariadb?

The TIMESTAMP() function in MariaDB is used to convert a date or datetime expression into a DATETIME value.

How the NTILE() function works in Mariadb?

The NTILE() function is a window function that divides a result set into a specified number of groups of approximately equal size.

How the JSON_SET() function works in Mariadb?

The JSON_SET() function is a JSON function that inserts or updates data in a JSON document and returns the result as a JSON document.

How the TIMEDIFF() function works in Mariadb?

The TIMEDIFF() function in MariaDB is used to calculate the difference between two time or date-time expressions.

How the NOW() function works in Mariadb?

The NOW() function is a date and time function that returns the current date and time.

How the JSON_SEARCH() function works in Mariadb?

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

How the TIME-function() function works in Mariadb?

The TIME() function in MariaDB is used to extract the time portion from a datetime or time expression.

How the NOT REGEXP operator works in Mariadb?

The NOT REGEXP operator is a logical operator that tests whether a string value does not match a regular expression.

How the JSON_SCHEMA_VALID() function works in Mariadb?

The JSON_SCHEMA_VALID() function is a built-in function in Mariadb that allows you to validate a JSON document against a JSON schema.

How the TIME_TO_SEC() function works in Mariadb?

The TIME_TO_SEC() function in MariaDB is used to convert a time value into the corresponding number of seconds.