Build or host a website, launch a server, or store your data and more with our most popular products for less.
Stock-AssoshutterstockTo permanently delete one or more tables in MariaDB, the `DROP TABLE` command can be used. Because the command irrevocably removes specified tables, it should only be accessible to authorized users. In this dedicated article, we will explain more about the command and its options…
MariaDB data types can be divided into five categories. While numeric data types and time and date specifications are for numbers, strings can contain various characters. The database management system also allows geometric data types and some types of data that do not fall into…
Maksim KabakoushutterstockWhen 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…
REDPIXEL.PLShutterstockIf 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 CreativityshutterstockIf 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…
To create a new account, you can use the CREATE USER command in MariaDB. In this article, we’ll not only explain step by step how to use the command and create a new user, but also show you which user rights you can assign to users. We’ll also explore different clauses you can…
sakkmesterkeshutterstockMariaDB 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…
Mr. KosalShutterstockMariaDB has been a recommended alternative to MySQL for a while. Integrating the SQL server into your LAMP stack can be done easily without any problems. In this dedicated guide, we explain how to install MariaDB on Ubuntu 22.04, and then how to configure it and implement…
NDAB CreativityshutterstockSince MariaDB is included in Debian’s repository by default, you can easily install the SQL server. In this article, we will explain how to install MariaDB on Debian 12, how to configure the software afterward, and what options are available to enhance the server’s security. We…
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…