This article shows you how to use the MySQL SHOW INDEX statement to list the details of indexes and keys in a table. To use the SHOW INDEX statement, you will need to know which database and table you wish to view index information for. Looking to list the databases… Read More »The MySQL/MariaDB ‘SHOW INDEX’ Statement, With Examples
The MySQL DISTINCT operator returns only unique values from a column from a database table; duplicates are not returned. Here’s how to use it. The DISTINCT operator can be useful in many scenarios; for example, you may want to generate a list of countries you have… Read More »The MySQL/MariaDB ‘DISTINCT’ Statement, With Examples
MySQL (and its functional equivalent, MariaDB) have two things named TRUNCATE – so watch out which one you want to use or suffer dire consequences! This article outlines the difference and usages of the MySQL TRUNCATE function and TRUNCATE TABLE statement – they share similar names but do very different things.… Read More »The MySQL (and Maria DB) TRUNCATE Command, With Examples (And Warning!)
This tutorial covers limiting the number of results from a MySQL database query using the LIMIT clause and skipping results using the OFFSET clause. This is especially useful when wanting to paginate results in web applications – spreading them out over several pages by retrieving a subset of the database results.… Read More »The MySQL LIMIT and OFFSET Clauses [with Examples]
There are two things called CASE in MySQL (and, by extension, the compatible MariaDB). The CASE Operator, for use in queries. The CASE Statement, for use in stored programs and procedures. Both have similar syntax and the same purpose. Both MySQL CASE Operator and Statement provide… Read More »MySQL CASE Statement and CASE Operator – Difference and Examples
There is a lot of weird-sounding language around databases. Most of it centers on the names of the popular database software which is available. It can make it tough to choose. Each strangely named database solution offers features making it suitable for different tasks. This… Read More »MySQL vs MariaDB vs MongoDB vs PostgreSQL vs SQLite vs MS SQL – Which to Choose?
Knowing which version of MySQL you are running is vital when making sure your code is compatible and that you are using supported features. Here’s how to find out which you are running. For example, older versions of MySQL lack features for handling JSON data and… Read More »How To Check your MySQL (Or MariaDB) Version [Easy]
MySQL SELECT queries are commands that pull data from your database tables according to conditions each record must meet. Complex queries will often need to combine the results from two or more SELECT queries – this is what the UNION operator does. UNION Syntax SELECT… Read More »Using the ‘UNION’ Operator in MySQL and MariaDB
In this guide, we cover foreign key constraints in MySQL and MariaDB, along with a number of useful examples. MySQL (and its fork MariaDB) are Relational Database Management Systems (RDBMS) – Database Systems which hold data in tables which can be related to each other. Tables in… Read More »Guide to Foreign Key Constraints in MySQL and MariaDB [With Examples]
This guide explains how to list databases and tables using MySQL or MariaDB using simple commands. Managing your databases from the Linux shell is quick and efficient compared to some of the bloated database management tools available. Here’s a quick primer on seeing what databases… Read More »Listing Databases and Tables in MySQL and MariaDB