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…)Database Programming
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…)MySQL Workbench GUI – Create Table
In this blog post, you will learn how to create a MySQL table using the various tools MySQL Workbench provides without typing any SQL code. Continue reading and learn how…
(more…)MySQL SUBSTRING() Function With Examples – Substack Repost
It’s no secret that text or string data are one of the most common datatypes you will process. At times, only a specific portion of a string may be needed and this is the perfect use case for the SUBSTRING() character function…
(more…)MySQL ALTER TABLE – Add Multiple Columns
I recently needed to add multiple columns to an existing table to store summary data calculations and wondered if I could do it in one MySQL ALTER TABLE statement. Turns out you can. And, it’s super simple. Convenient too. Continue reading and learn what I learned…
(more…)