What’s missing? Find out using OUTER JOIN’s in MySQL with examples.

What’s missing? What matches in one table but not another? MySQL (and SQL in general) have a way to find out. More than likely, when working with a normalized database, you are faced with these types of questions. Querying multiple tables with JOIN‘s on matched values, only goes so far to answering this type of question. We will see how to leverage an OUTER JOIN, for these requests.
divider

INNER JOIN in MySQL with examples.

To normalize data, we often store it in several tables within a given database. While querying those tables individually can provide answers to numerous questions around that data, more times than not, it leaves us ‘coming up short’ for the complete answer we need.
That poses the question of, how do you extract all this data from several tables that depend on one another to provide data-driven answers?
One tried and true method is to use a JOIN operation.

(more…)

MySQL String Data Type Dive: CHAR and VARCHAR – Differences.


Data types… They are oh so important when designing your database tables. In this blog post, I look at two similar string data types: CHAR and VARCHAR. Chances are you will likely use one, the other, or both in MySQL. But what is the difference in them? I want to know myself. So let’s learn together…

(more…)