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.
Code, content, and community for developers.
The LAMP stack and the PHP technologies and frameworks it runs.
More ways I can help
- Need hosting for your next web application or WordPress site? I highly recommend Hostinger and use them to host my niche bass fishing site. The service is second to none.
- Desktop and mobile wallpapers, digital downloads, photography services, Shopify and WooCommerce customizations, and content writing – all in one E-commerce Shop. Find your next digital purchase today!
- Take your Laravel applications next level with Battle Ready Laravel by Ash Allen. Learn how to improve the performance, maintainability, and security of your Laravel projects in this e-book.
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.
Code, content, and community for developers.
The LAMP stack and the PHP technologies and frameworks it runs.
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!
Code, content, and community for developers.
The LAMP stack and the PHP technologies and frameworks it runs.