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
This article will show you, with examples, how to show what database privileges users have in MySQL and MariaDB. List All Users To show the privileges for a user, you need to be able to query the user’s name. Here’s how to generate a list… Read More »Show Privileges in MySQL/MariaDB using SHOW GRANTS, With Examples
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
