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…

Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don’t know where to start. Learn more about the premium blog posts as I develop and release them.

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

How can I help you?

Are you thinking of starting up a blog? I use WordPress for my blog. Let’s both save money on the plans offered. Grab a Gmail HTML Email Signature template from my Etsy shop and make your emails pop and stand out. Need hosting for your next web application or WordPress site? I use and highly recommend Hostinger. They have great pricing and service.I enjoy reading Refind: The essence of the web, every morning in your inbox. Subscribe for free. Help me get a premium subscription by signing up yourself with my referral link.Grab a free pack of mobile Creator wallpapers.Just getting started or wanting to learn MySQL? Find out about my premium blog posts and MySQL Beginner Series here.

Disclosure: Some of the services and products links in this post 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

The post OpenLampTech MySQL Extras – Substack Writing appeared first on Digital Owl’s Prose.