Anyone operating a blog, newsletter, or other creative side hustle knows there are a lot of moving pieces involved behind the scenes. Keeping the cadence going not only requires commitment and skills, but also various tools and software…
(more…)Blog
MySQL WHERE Clause Equality Comparison Operator
We don’t always need all rows from the table as part of the final results set. You can use one (or more) of the comparison operators to filter the rows with a WHERE clause conditional. In this post, we are looking at the equality comparison operator (=)…
(more…)MySQL DATE() Function with examples
The MySQL DATE() function is a built-in function you use to extract just the date portion from a DATE or DATETIME value. Learn how to use the DATE() function in this blog post…
(more…)Python vs. PHP: Which is Better for Web Development?
In the digital world, web development has become one of the most in-demand skills. The biggest companies have already invested in developing their website to help boost business and brand identity. When first developing a website, you may be wondering which programming language to use.
(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…)