Articles

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

How to Install SQLite on Oracle Linux 7 (Legacy Guide)

Install SQLite on Oracle Linux 7 for an existing system. Premier Support ended in 2024; Extended Support is subscription-based. Use a current release for new deployments.

How to use the MySQL YEAR() function

In this article, we will learn how to use the YEAR() function in MySQL. The YEAR() function returns the year for a given date or datetime expression.

How the CASE expression works in Mariadb?

The CASE expression is a conditional operator that allows you to execute different statements based on one or more conditions.

How to Install SQLite on openSUSE: A Step-by-Step Tutorial

SQLite is a lightweight, high-performance, self-contained relational database management system that is widely used for various applications. If you’re using openSUSE and want to install SQLite, this step-by-step tutorial will guide you through the process.

How to use the MySQL WEEKOFYEAR() function

In this article, we will learn how to use the WEEKOFYEAR() function in MySQL. The WEEKOFYEAR() function returns the week number for a given date, based on the ISO 8601 standard.

How the BOUNDARY() function works in Mariadb?

The BOUNDARY() function in MariaDB is designed to return the boundary of a geometric object.

How to Install SQLite on macOS: A Step-by-Step Tutorial

SQLite is a lightweight, high-performance, self-contained relational database management system that is widely used for various applications. If you’re using macOS and want to install SQLite, this step-by-step tutorial will guide you through the process.

How to use the MySQL WEEKDAY() function

The WEEKDAY() function returns the index of the weekday for a given date, where Monday is 0 and Sunday is 6.

How the BIT_XOR() function works in Mariadb?

MariaDB’s BIT_XOR() function is used to perform a bitwise exclusive OR (XOR) operation on all bits in a given expression.

How to Install SQLite on FreeBSD: A Step-by-Step Tutorial

SQLite is a lightweight, high-performance, self-contained relational database management system that is widely used for various applications. If you’re running FreeBSD and want to install SQLite, this step-by-step tutorial will guide you through the process.