ra2 studioShutterstockSince 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…
SQL ISNULL() is a practical function for checking the value of an expression. If a value is NULL, the function replaces it with a substitute value that you define in advance. In our dedicated article, we explain how this works using practical examples and reveal some of the…
The SQL EXISTS operator allows you to check whether a subquery contains a specific value. You can incorporate this subquery into a higher-level query and use it as a condition for execution. In this dedicated article, you will learn the structure of SQL EXISTS and find out how to…
ChinnapongShutterstockFor table or column names that are long or difficult to read, it can help to create a temporary alternative name that’s simpler. SQL aliases do just this, providing simplified column and table names for queries. These aliases are only applied while the query is being carried out…
If you no longer need a database, you should permanently remove it using the SQL DROP DATABASE command. This dedicated guide explains how to use this command to get rid of single or multiple databases, explains what you should keep in mind when doing so, and lists the associated…
It’s easy to lose track of things in large datasets. The SQL LIKE operator is an essential tool for searching databases and making efficient queries. In this tutorial, we explain what the SQL LIKE operator is, what it’s used for and how to use SQL wildcards. We also show you…
Ranjit KarmakarshutterstockDo you need to update or change a table in SQL? The SQL UPDATE command allows you to update entries in a table as a whole or carry out changes on selected entries. In this article, we tell you everything you need to know about UPDATE, including its syntax, what it’s useful for…
If you wish to install MariaDB on Debian 10, it can be done without any problems. Debian contains this database management system and provides the required packages. In this article, we will guide you through the installation process, outline the crucial steps, and show you how…
Elena KharichkinaShutterstockAs CentOS 7 reached its “end of life” (EOL) this summer, users will need to explore migrating to a new operating system to maintain security and performance. We highlight three particularly recommended alternatives to CentOS and thoroughly outline the pros and cons of each option…
Rawpixel.comshutterstockMastodon is a decentralized social network using open-source software. Similar to Twitter, it allows users or organizations to run their own servers (instances). You can scale your Mastodon server as your community grows while maintaining control over your data. We explain…
Build or host a website, launch a server, or store your data and more with our most popular products for less.
