Databases

MySQL Truncate

The MySQL (and Maria DB) TRUNCATE Command, With Examples (And Warning!)

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!)

Which database to Choose

MySQL vs MariaDB vs MongoDB vs PostgreSQL vs SQLite vs MS SQL – Which to Choose?

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?

Guide to Foreign Key Constraints in MySQL

Guide to Foreign Key Constraints in MySQL and MariaDB [With Examples]

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]