Here are some great open source SQL blog posts and articles I enjoyed reading this week… Enjoy and share them along…
Date information tracking and storage is integral to companies, services, and applications. Imagine if your employer did not keep up with how many hours you worked? Or which days? Neither party involved could benefit. I’m confident such a company would have vacancies abound. This blog post will visit many of the available date functions offered in MySQL, to assist managing this all-important data type.
Assembled below in no particular order are some interesting articles I stumbled upon throughout the week on the webs…
Enjoy and share.
Part 1 of this two-part series, discussed the requirements for implementing data integrity checks using a
TRIGGER. With the success of that
TRIGGER, this second blog post will dive into its workings, gaining an understanding of how the checks are performed, along with the
Note: All data, names or naming found within the database presented in this post, are strictly used for practice, learning, instruction, and testing purposes. It by no means depicts actual data belonging to or being used by any party or organization.
I will be using Xubuntu Linux 16.04.3 LTS (Xenial Xerus) and MySQL 5.7.21 for these exercises.