Articles

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

How the BIT_AND() function works in Mariadb?

MariaDB’s BIT_AND() function is used to perform a bitwise AND operation on all bits in a given expression.

How to Install SQLite on Debian 10 (Legacy Guide)

Install SQLite on Debian 10 for an existing system. Official Debian LTS ended in June 2024; use a supported release for new deployments.

How to use the MySQL UNIX_TIMESTAMP() function

In this article, we will learn how to use the MySQL UNIX_TIMESTAMP() function, which returns the number of seconds since the Unix epoch (1970-01-01 00:00:00 UTC) for a given date or datetime value.

How to Install SQLite on CentOS Stream 9: 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 CentOS Stream 9 and want to install SQLite, this step-by-step tutorial will guide you through the process.

How to use the MySQL TO_SECONDS() function

In this article, we will learn how to use the MySQL TO_SECONDS() function, which returns the number of seconds from year 0 to a given date or datetime value.

How the BINARY operator works in Mariadb?

The BINARY operator in MariaDB is used to force a binary collation on the operand.

How to Install SQLite on CentOS Stream 8 (Legacy Guide)

Legacy guide to installing SQLite on CentOS Stream 8, which stopped receiving builds in May 2024. Use a supported release for new systems.

How to use the MySQL TO_DAYS() function

In this article, we will learn how to use the MySQL TO_DAYS() function, which returns the number of days from year 0 to a given date.

How the BIN() function works in Mariadb?

The BIN() function in MariaDB is a simple yet powerful function used to convert a decimal number into its binary equivalent.

How to Install SQLite on CentOS 8 (Legacy Guide)

Install SQLite on CentOS Linux 8 for an existing system. CentOS 8 support ended in 2021; use a maintained Linux release for new deployments.