kentohShutterstockMySQL is one of the most widely used database management systems worldwide. The open-source software has been available since 1995 and is considered the standard solution for relational databases. However, MariaDB is becoming an attractive alternative. We compare both systems and…
RDVectorShutterstockIf you want to back up or restore MySQL or MariaDB databases, you can use the command line to do so. This tutorial walks you through the process of importing and exporting databases—both in MySQL and MariaDB. In this dedicated article, you’ll learn how to create an empty…
Wright StudioshutterstockIn terms of databases, alternatives to the SQL approach have existed for quite some time. The advantages of a relational system shouldn’t be overlooked though. In fact, it might be exactly what your project requires. Here, we’ll go over which NoSQL solutions are worth considering…
Connect worldshutterstockMySQL is one of the best-known solutions in the relational database segment. But if you’re seeking a NoSQL companion to your SQL database or are aiming to get around rigid table structures altogether, it makes sense to explore NoSQL options. In this article, we’ll take a look at…
REDPIXEL.PLshutterstockWith the SQL AND operator, you can implement various conditions in a WHERE query, allowing you to include or exclude different entries. In this article, we’ll explain what the operator is and the syntax for it. Using practical examples, we’ll go over how to use the operator as…
STILLFXshutterstockIt seems like almost every day a new software vulnerability is uncovered or an existing one is patched. One attack method that has long exploited such weaknesses is the SQL injection. But what exactly are these malicious database exploits, how do they work, and—most…
Large data sets can quickly get confusing! Commands like SQL SELECT TOP, LIMIT and ROWNUM allow you to limit query results to a number of your choosing. That makes results easier to read and increases efficiency and performance. In this tutorial, we show you how to use SELECT TOP…
When working with complex datasets, it’s important to be able to perform efficient, precise searches. One tool that can help with that is the logical operator OR. SQL’s OR returns records that meet at least one of two conditions. In this tutorial, we explain everything you need…
REDPIXEL.PLShutterstockWhen analyzing and processing data, it’s essential to be able to select relevant records. SQL SELECT is the main tool for selecting relevant columns and records in SQL. When combined with other operators and commands, SELECT has a wide variety of potential uses. In this tutorial,…
Paolo SchorlishutterstockWhether you need to calculate total costs, sales, order quantity or any other value, SQL SUM can do a large part of that mathematical work for you! As an aggregate function that adds up all the values in a column, it is an indispensable tool in SQL. In this tutorial, we show you…