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.

MySQL Tutorial PostgreSQL Tutorial MySQL Reference PostgreSQL Reference SQLite Function Reference MariaDB Reference MongoDB Reference Oracle Reference SQL Server Reference Sakila Tutorial

A Complete Guide to the MySQL BIN() Function

MySQL BIN() Function converts a decimal number to its binary representation, making it useful for debugging bitwise operations and analyzing data storage.

A Complete Guide to the MySQL BETWEEN Operator

Learn how to use the MySQL BETWEEN operator to filter data based on a range of values, including numbers, dates, and strings.

A Complete Guide to the MySQL BENCHMARK() Function

MySQL BENCHMARK() Function allows you to execute an expression multiple times and measure how long it takes, helping you identify potential bottlenecks or compare different approaches.

A Complete Guide to the MySQL AVG() Function

MySQL AVG() Function calculates the average value of a numeric column, making it essential for data analysis and reporting.

A Complete Guide to the MySQL ASCII() Function

MySQL ASCII() Function allows you to retrieve the numeric ASCII code of the leftmost character in a string, making it a fundamental tool for character manipulation and analysis.

A Complete Guide to the MySQL AES_ENCRYPT() Function

MySQL AES_ENCRYPT() Function provides a straightforward way to implement robust AES-128 encryption directly in your database queries, ensuring your data remains secure at rest.

A Complete Guide to the MySQL AES_DECRYPT() Function

MySQL AES_DECRYPT() Function reverses the encryption performed by AES_ENCRYPT(), allowing you to securely retrieve original data when needed.

A Complete Guide to the MySQL ADDTIME() Function

MySQL ADDTIME() Function allows you to add a time interval to a time or datetime value, making it an essential tool for time-based calculations in databases.

A Complete Guide to the MySQL ADDDATE() Function

MySQL ADDDATE() Function allows you to add a specified time interval to a date, making it an essential tool for date manipulation in databases.

How the ST_RELATE() function works in Mariadb?

The MariaDB ST_RELATE() function is a powerful spatial function that provides detailed insights into how two geometries interact, using the Dimensionally Extended 9-Intersection Model (DE-9IM).

How the ST_PolygonFromWKB() function works in Mariadb?

The MariaDB ST_PolygonFromWKB() function is essential for converting Well-Known Binary (WKB) representations of polygons into spatial data types, enabling efficient storage and analysis of geographic information.

How the ST_PolygonFromText() function works in Mariadb?

The MariaDB ST_PolygonFromText() function is essential for converting Well-Known Text (WKT) representations of polygons into spatial data types, enabling efficient storage and analysis of geographic information.

How the ST_PolyFromWKB() function works in Mariadb?

The MariaDB ST_PolyFromWKB() function is a powerful tool for converting Well-Known Binary (WKB) representations of polygons into spatial data types, enabling efficient storage and analysis of geographic information.

How the ST_PolyFromText() function works in Mariadb?

The MariaDB ST_PolyFromText() function is a powerful tool for converting text representations of polygons into spatial data types, enabling efficient storage and analysis of geographic information.

How the ST_POINTONSURFACE() function works in Mariadb?

The ST_POINTONSURFACE() function is a powerful tool for obtaining a point that lies on the surface of a given geometry, whether it’s a polygon or a linestring.

How the ST_POINTN() function works in Mariadb?

The MariaDB ST_POINTN() function is a powerful tool for extracting specific points from linestring geometries, allowing for detailed spatial data analysis.

How the ST_IsRing() function works in MariaDB?

The ST_IsRing() function in MariaDB is used to determine whether a given linestring geometry forms a closed ring.

How the ST_ISEMPTY() function works in MariaDB?

The ST_ISEMPTY() function in MariaDB is used to determine whether a given geometry is empty or not.

How the ST_ISCLOSED() function works in MariaDB?

The ST_ISCLOSED() function in MariaDB is used to determine whether a given geometry is closed or not.

How the ST_INTERSECTS() function works in MariaDB?

The ST_INTERSECTS() function in MariaDB is used to determine whether two given geometries intersect or overlap with each other.

How the ST_INTERSECTION() function works in MariaDB?

The ST_INTERSECTION() function in MariaDB is used to calculate the geometric intersection between two geometry values.

How the ST_InteriorRingN() function works in MariaDB?

The ST_InteriorRingN() function in MariaDB is used to retrieve the N-th interior ring of a Polygon geometry. Interior rings are the rings that define holes or inner boundaries within a polygon.

How the ST_GeomFromWKB() function works in MariaDB?

The ST_GeomFromWKB() function in MariaDB is used to construct a geometry value from a Well-Known Binary (WKB) representation of a geometry.

How the ST_GeomFromText() function works in MariaDB?

The ST_GeomFromText() function in MariaDB is used to construct a geometry value from a Well-Known Text (WKT) representation of a geometry.

How the ST_GEOMETRYTYPE() function works in MariaDB?

The ST_GEOMETRYTYPE() function in MariaDB is used to retrieve the type of a geometry value.

How the ST_GEOMETRYN() function works in MariaDB?

The ST_GEOMETRYN() function in MariaDB is used to return the N-th geometry from a collection of geometries, allowing for efficient extraction of individual geometries from collections.

How the ST_GeometryFromWKB() function works in MariaDB?

The ST_GeometryFromWKB() function in MariaDB is used to construct a geometry value from a Well-Known Binary (WKB) representation of a geometry.

How the ST_GeometryFromText() function works in MariaDB?

The ST_GeometryFromText() function in MariaDB is used to construct a geometry value from a Well-Known Text (WKT) representation of a geometry.

How the ST_GeometryCollectionFromWKB() function works in MariaDB?

The ST_GeometryCollectionFromWKB() function in MariaDB is used to construct a GeometryCollection value from a Well-Known Binary (WKB) representation of a geometry collection.

How the ST_GeometryCollectionFromText() function works in MariaDB?

The ST_GeometryCollectionFromText() function in MariaDB is used to construct a GeometryCollection value from a Well-Known Text (WKT) representation of a geometry.