Weekly Reading for week of 02/09/2019

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…


Data Type as validation constraint – with example in MySQL

Oftentimes, those less-than-obvious gems of programming go unnoticed. Some things are in place for us to utilize, yet we never think about them. In this blog post, I will cover how you can use the integer data type itself, as a sort of validation constraint for data coming into your table(s). Of course, all situations are unique, so this is not a one-size-fits-all solution. However, under the right circumstances, it could be a handy little trick to have up your sleeve.

[Head this way for more great MySQL blogging >>>]

Understanding MySQL’s IF() function – with examples.

Conditional logic is integral for just about any application. Most programming languages support some form of if/else construct. MySQL is a dialect of SQL, which is a declarative language. But, it also includes support for conditional flow as do other languages such as Python, PHP, and Java. In this blog post, I will look at the IF() Function for similar if/else type of functionality.

[Head this way for more great MySQL blogging >>>]