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…)Latest Blog Posts
OpenLampTech issue #26 – Substack Repost
Your one-stop source for excellent PHP/MySQL technical content is here again this week for your reading pleasure. Enjoy this selection of articles I read and learned something from this week. Thank you for being here!
(more…)Multiple WHERE Clause Conditionals Using the MySQL AND Logical Operator
Oftentimes, you need multiple filter conditionals in a WHERE clause in order to target specific rows of data. Continue reading this blog post and learn how to use the AND logical operator in WHERE clause queries…
(more…)OpenLampTech issue #25 – Substack Repost
You know what time it is, right? Yep, it is time for OpenLampTech issue #25. There are several great reads in this week’s newsletter for PHP/MySQL developers. Enjoy them at your leisure and share the publication with other’s who will like the content as well…
(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…)