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…)SQL
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…)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…)