OpenLampTech MySQL Extras – Substack Writing

Not only do I share the weekly OpenLampTech newsletter, but I’m also publishing some articles outside of the publication, directly to my Substack page. I’m resharing the last 2 I’ve posted over on my Substack for any interested readers…


Discover premium articles, in-depth guides, instructional videos, and much more by joining the “MySQL Learning Tier” membership. You have access to exclusive content unpublished anywhere else with this membership. With new content being added regularly, continue learning MySQL at any level.



MySQL SHOW TABLES – Two Variations

This post is an excerpt from some premium content I am creating here on my blog for beginners wanting to learn MySQL.

Read the full substack article: MySQL SHOW TABLES – 2 Variations.

Related: MySQL Beginners Series — The SELECT statement.

MySQL ROW_NUMBER() with CASE Expression

This post is another one I had a lot of fun writing because I learned so much while putting it together.

I’m covering how to collapse multiple rows into a single row per distinct group. The ROW_NUMBER() window function is key here and is center stage in this article.

Read the full substack article: MySQL ROW_NUMBER() Window Function with CASE Expression.


OpenLampTech is the newsletter for PHP/MySQL developers. Get the best original and curated content delivered directly to your inbox each week for free. Help build a great community by signing up today.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

More ways I can help

Disclosure: Some of this blog post’s services and product links are affiliate links. At no additional cost to you, should you make a purchase by clicking through one of them, I will receive a commission.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Disclosure: Some of this blog post’s services and product links are affiliate links. At no additional cost to you, should you make a purchase by clicking through one of them, I will receive a commission.

If you found value in this post, you can show your appreciation and buy me a coffee. It is my favorite drink!

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Hey thanks for commenting! Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.