Handy MySQL Date functions with examples.

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.

Monitor data in MySQL with Cursors and Stored Procedures.

MySQL cursors traverse rows in a table. Okay…but why use them? In this blog post, we will look at a CURSOR within a stored procedure that returns specific records of interest.


Squash repeatedly typing the same query – Use a MySQL VIEW instead.


Photo by Arnaud Papa on Unsplash

Do you find yourself repeatedly typing the same query? Want to save it for reuse? A VIEW to the rescue it is! In this blog post we will look at a scenario and a VIEW that fits this very need.


MySQL Triggers for Data Integrity – In lieu of Check Constraints Part 2.


Photo by Todd Quackenbush on Unsplash

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 TRIGGER itself.

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.