JOINs, and some VIEWs, in MySQL

Apr 30, 2015

This is the third in a series of posts on MySQL. The first post covered setting up MySQL and basic queries and the second post covered simple queries using SELECT, LIMIT, ORDER BY, etc. If you are starting out, you should start with these posts. In this post I will go over multi-table queries, using JOINs (with some help from VIEWs).

Employees database for MySQL, setup and simple queries

Apr 22, 2015

In a recent post I covered MySQL setup on Ubuntu 14.04. In this post I will cover downloading and setting up the employees sample database that will be used for the example queries in this, and other posts, on my blog. As mentioned in the previous post, I'm using Jump Start MySQL as a guide book for these posts-- you should check it out for more examples.

Installing MySQL on Ubuntu 14.04

Apr 21, 2015

In this post I will cover installing MySQL on Ubuntu 14.04, using the repository available at the mysql apt repo. The idea is to setup a repository that allows our MySQL to be current-- in this case MySQL 5.6. The instructions I'm documenting here are derived from the above link, as well as the nice book Jump Start MySQL (April 2015). If this is of interest to you, follow along and be sure checkout the resources mentioned above.