Databases

This quick article will demonstrate how to use the MySQL/MariaDB COUNT function to count the number of records returned by a query. MySQL/MariaDB COUNT Function Syntax COUNT(query) Note that: query can be an SQL query or a string representing a column name Null values found… Read More »How to Use the MySQL/MariaDB COUNT Function, With Examples

Being able to delete data from a table in a database is a pretty important thing – This article will show you how it’s done in MySQL/MariaDB. MySQL DELETE Statement Syntax In its basic usage, the DELETE operator is used in conjunction with a WHERE… Read More »The MySQL/MariaDB DELETE Statement – How to Use It

This short article will show you how to list all of the users on your MySQL server. MySQL Users and Permissions MySQL databases usually have access granted to only certain users, each with their own permissions limiting what they can and can’t do on that… Read More »How to List/Show Users in MySQL/MariaDB

This article will show you how to use the MySQL/MariaDB UPDATE statement to update existing database records. MySQL/MariaDB UPDATE Syntax The syntax for the MySQL UPDATE statement requires the use of two keywords, UPDATE, and SET, and is as follows: UPDATE table SET column = value WHERE conditions; Note that:… Read More »How to Update Records – MySQL UPDATE Statement

This article will explain and demonstrate the use of aliases in MySQL (and MariaDB). MySQL queries can get pretty gnarly – especially if you’re selecting multiple columns from multiple tables. An alias statement is a great tool for simplifying these queries. An alias is just another name… Read More »How to Use MySQL ‘alias’ to Make Queries Easier to Read

Here is an article outlining several methods for running SQL files in MySQL on Linux/Ubuntu. Whether you’re installing a package, following a tutorial, or restoring a backup – it’s useful to be able to execute an SQL script and have it do all of the… Read More »How to Run a SQL File in MySQL/MariaDB on Linux/Ubuntu

This article will demonstrate the usage of the SQL CHECK Constraint to limit column values, as used in MySQL/MariaDB. The SQL CHECK constraint allows you to define limitations to the value which can appear in a table column. It also allows you to apply constraints to a… Read More »Limit Column Values With The MySQL CHECK Constraint [Examples]

This article will show you how to find the default or current MySQL (or MariaDB) port and how to change it. What is a Port? A port is a numerical identifier for a communication endpoint on a computer network. Or, put simpler, it’s a unique number on… Read More »Default MySQL/MariaDB Port, Finding It, Changing It

This article will show you the BEST way to copy a table, with or without the data in it, in MySQL and MariaDB. Copying the Table with All Data in MySql The following code will copy a table including all data using the CREATE TABLE… Read More »Copy a Table in MySQL/MariaDB – How To, With Examples

There are one of two things you might be looking for – merging two MySQL tables, or the MERGE TABLE syntax – this article explains both, with examples. Merging Tables in MySQL (Moving Data From One Table Into Another) A note before I get to the code… Read More »Merge Tables in MySQL (UNION/MERGE TABLES) – Tutorial