Programster's Blog

Tutorials focusing on Linux, programming, and open-source

PHP - Using UUID Instead of Auto Increment or Sequence

Learn how to use UUIDs in MySQL for your table IDs, rather than using auto_increment.

CentOS - Install MariaDB 5.5

Install MariaDB 5.5 on CentOS 7

MySQLi Prepared Statements

A brief tutorial on using prepared statements and their pros/cons.

MySQL GIS Cheatsheet

A cheatsheet for using GIS with MySQL

Selecting Data From Split Tables

A couple of examples of using joins or nested queries to select and combine data from multiple tables.

MySQL - Unique Key Across Tables

Can MySQL ensure that if a value is in one table, it doesn't exist in the other?

MySQL - Foreign Keys on Foreign Keys

Can you create a foreign key that references a column in another table that itself is a foreign key that references a column in another table?

Debian 9 - Install MySQL Server

This tutorial will show you how to install various versions of MySQL server on Debian 9.

Set MySQL Timezone

MySQL Enums

MySQL - History Tables

MySQL Decimal

MySQL - Foreign Keys

MySQL Integer Types

Solving MySQL InnoDB Corruption

CentOS - Install MySQL Server

Debian 8 - Install MySQL 5.7

What's New In MySQL 5.7

MySQL 5.7 New JSON Functionality

Ubuntu 14.04 - Install MySQL 5.7

MySQL - Replace Statements

MySQL - Prevent Defaulting to Allow Defaults

MySQL Query Cheatsheet

A cheatsheet for MySQL queries.

MySQL Temprorary Tables

MySQL Configuration Variables

MySql Partitions

Basic MySQL Commands

MySQL administration cheatsheet.

MySQL Left Joins

MySQL Timestamps Automatically Update

Debian - Move MySQL Database To Another Disk

Debian 8 - Install MySQL 5.6