What are the different data types in MariaDB?

ra2 studioShutterstock

How to install MariaDB on Ubuntu 20.04

Since MariaDB is a drop-in replacement for MySQL, you can also use the fork as part of your LAMP stack without any problems. In this article, we explain how to install MariaDB on Ubuntu 20.04, which configurations and security measures are recommended and how you can easily check…

REDPIXEL.PLShutterstock

How to install MariaDB on Debian 11

MariaDB packages are included by default in Debian. So, if you wish to use the SQL server with the operating system as part of the LAMP stack, it can be done easily. In this article, we will walk you through the step-by-step process of installing MariaDB on Debian 11, and also…

Maksim Kabakoushutterstock

How to query and merge records using MariaDB JOIN

When working with several tables, it’s often necessary to combine data records. In MariaDB, you can use the JOIN statement to do this. In this article, we explain how the command works and how the different variants INNER JOIN, LEFT OUTER JOIN and RIGHT OUTER JOIN differ from…

sakkmesterkeshutterstock

How to choose a database using SELECT DATABASE in MariaDB

MariaDB offers two methods for selecting a database within its management system. In this dedicated article, we illustrate how to use the USE statement in the command line and the mysql_select_db function in PHP with a straightforward example, and also highlight what you need to…

REDPIXEL.PLShutterstock

How to use MariaDB CREATE DATABASE

If you want to create a new database using the free and open-source relational database management system MariaDB, you can use the CREATE DATABASE command. This article provides a detailed explanation of how the command functions and explores various optional parameters that can…

NDAB Creativityshutterstock

How to use MariaDB CREATE TABLE

If you want to create a new table, you can use CREATE TABLE in MariaDB to do so. The statement not only means that a new table is created, but also creates the individual columns and the data types permitted in them. In this article, we explain exactly how CREATE TABLE works in…