SQL

Weekly Reading for Week of 09-22-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

FOREIGN KEY Referential Actions in MySQL – with examples.

In FOREIGN KEYS in MySQL with examples. I discussed establishing referential integrity between multiple tables sharing related and associated data using a FOREIGN KEY. However, the included syntax examples were not completely covered. In particular, the actual definition of the referential action. In this blog post I will continue with this concept and cover those definitions, their meanings, and example use…

You’re headed for more great MySQL blogging…

Weekly Reading for week of 09-15-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…

FOREIGN KEYS in MySQL with examples.

Oftentimes, we use multiple tables in a database to meet normalization best practices. Among the normal forms, we also must ensure some type of integrity for related data spread out between multiple tables. A FOREIGN KEY, along with specific constraints, can be used for this…

Like MySQL? Me too! You’re in the right place! Keep reading…