Understanding WHERE clause execution in MySQL with Derived Tables.

As I continue to learn MySQL, revisiting the fundamentals is of course, beneficial. As a matter of fact, it is integral for me to solidify many basic concepts. Nevertheless, most tutorials and blog posts only cover syntax for the chosen database.

Knowing the correct syntax is a must. But, something often overlooked is the execution order of the clauses, forming the foundation for queries. Which in turn, are very much different from their processing order. In this blog post, I will explore one of several differences. Referencing aliased column names in the WHEREclause…

[Interested in MySQL? Me too! You are in the right place!]

Advertisements

Quick and easy INSERT’s in MySQL with the SELECT statement.

The SELECT clause has more uses than just returning those columns you specify in your query. Want to see a handy use for it? Need to populate a table with values from another table? But don’t want to do it by hand? You are in luck…

[Want to know how? Keep reading…]

Understanding the UNIQUE constraint in MySQL – with examples.

Want to ensure no duplicate values are stored in your database table columns? Certain requirements often dictate that all values for a particular column (or columns) should not be identical and remain individually unique. But how do you ensure this is handled in the database, without your required, immediate intervention? The UNIQUE constraint. In this blog post, we will see how by example…

[Interested in MySQL? You’re in the right place!!!]

MySQL Data Type Dive: ENUM – With examples.

ENUM data types are an interesting lot to me. I have previously blogged – in a high-level sense – on incorporating them with a TRIGGER for a sort of check constraint, which MySQL does not have. But what exactly is an ENUM? What are its advantages and disadvantages over other string data types? When would you use it and why? Join me and we will learn together…

[More MySQL blogging >>>]

MySQL SELECT INTO Syntax Part 3 – DUMPFILE with examples.

We have seen in previous blog posts, 2 uses of the MySQL SELECT INTO syntax. Yet, there is a third use to know and learn about which we will explore in this blog post.

MySQL blogging this way >>>