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.

A Complete Guide to the MySQL CAST() Function

MySQL’s CAST() function is a versatile tool for converting data types, enabling flexible data manipulation and compatibility in queries.

A Complete Guide to the MySQL CASE Statement

MySQL’s CASE statement allows you to add conditional logic to your queries, enabling dynamic data transformations and custom categorizations.

A Complete Guide to the MySQL ^ (Bitwise XOR) Operator

MySQL’s XOR operator allows you to filter rows based on exclusive conditions, while the ^ operator performs bitwise XOR operations on integers.

A Complete Guide to the MySQL | (Bitwise OR) Operator

MySQL’s OR operator allows you to combine multiple conditions in a WHERE clause, returning rows that satisfy at least one condition. This guide covers its usage, examples, and best practices.

A Complete Guide to the MySQL & (Bitwise AND) Operator

MySQL’s & operator performs a bitwise AND operation on binary representations of integers, allowing for low-level data manipulation and bitmasking.

A Complete Guide to the MySQL BIT_XOR() Function

MySQL’s BIT_XOR() function performs a bitwise XOR operation across multiple values, allowing you to analyze binary data patterns and detect unique flags.

A Complete Guide to the MySQL BIT_OR() Function

MySQL’s BIT_OR() function performs a bitwise OR operation across multiple values, allowing you to aggregate binary data effectively.

A Complete Guide to the MySQL BIT_LENGTH() Function

MySQL’s BIT_LENGTH() function calculates the number of bits required to store a string, providing insights into text data storage and character encoding.

A Complete Guide to the MySQL BIT_COUNT() Function

MySQL’s BIT_COUNT() function counts the number of bits set to 1 in a binary number, making it easy to analyze bitmask flags and permissions.

A Complete Guide to the MySQL BIT_AND() Function

MySQL BIT_AND() function is a powerful function for performing bitwise AND operations across a set of values. This guide covers its syntax, usage, and practical examples.

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.