MySQL JOIN

JOIN is a SQL command to combine multiple columns from multiple tables into a single output.  I showed an example of a LEFT JOIN on the post about visualizing my MySQL data from Halloween 2015 here. There are four main types of SQL JOINS: LEFT, RIGHT, INNER, FULL OUTER.  If you read up on them, you […]

Read More

Data Types

We briefly covered data types in our post on building your first database here, but I wanted to dive a little bit deeper into the subject. When you enter data into a MySQL database, it will fall into one of three categories: Numeric String Date & Time Numeric There are many options if you want […]

Read More