Weekly Reading for Week of 11/10/2018

Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…


Advertisements

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!!!]

Weekly Reading for week of 11/03/2018

Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…


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 >>>]