Determine All Calendar Days in a Month with MySQL

Watch this quick in-depth video short and learn how to find all the calendar days for a specific month using built-in MySQL date functions and recursive Common Table Expressions (CTEs). This is a repost of a free article over on my Kofi page as part of the “MySQL Learning Tier” membership

(more…)

MySQL GROUP BY WITH ROLLUP – Substack Repost

I recently took some time to explore the MySQL GROUP BY WITH ROLLUP modifier. As a self-starter, I’m always unknowingly studying SQL concepts that I soon need for a query requirement. Call it luck or premonition, doesn’t matter to me. I’ll take these small wins thanks to my curiosity…

(more…)

OpenLampTech issue #24 – Substack Repost

Wow! This is the 6-month issue of the OpenLampTech newsletter. I’ve learned so much during this time in creating the newsletter for PHP/MySQL developers. Here’s to many more months of publishing! Enjoy this week’s articles!

(more…)