Writing a weekly newsletter is hard, dedicated work. But, I enjoy reading each week’s edition myself and I hope you do as well. OpenLampTech issue #49 is ready for you. Enjoy this week’s content!

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.

In OpenLampTech issue #49, we have content covering:

• Laravel Eloquent tips
• 13 Linux distros from scratch
• Improve your WordPress site’s performance
• Most popular databases for PHP
• And much much more

A free weekly subscription helps support the …

As of MySQL v8, we have Common Table Expressions (CTEs) or the WITH clause available. I recently learned how to use the WITH clause in an INSERT statement, similar to INSERT with SELECT. Like always, I enjoy sharing what I learn so let’s all learn together…

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.

For the sake of simplicity (and my sanity) I’m using this arbitrary sample data:

SELECT *
FROM auto_test;

We can use the WITH clause to generate a …

Welcome to this week’s OpenLampTech newsletter. I have many great articles curated for you this week. Thank you for reading and please share the publication with others.

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.

In OpenLampTech issue #47, we are looking at articles covering:

• MySQL Spatial data types
• Build a blog backend with Laravel
• 10 Linux command-line operators
• MySQL row locking
• And much more

Want to support the OpenLampTech publication? Easy enough.

Head on over to …

Once again, OpenLampTech has another full issue for all of your MySQL, PHP, and LAMP stack content. The publication continues to grow. Thank you all for reading.

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.

In OpenLampTech issue #45, enjoy articles covering:

• Symfony’s Twig
• MySQL PIVOT functionality
• Building a niche website with WordPress
• 10 popular Linux distros
• And much much more.

Want to know how you can support OpenLampTech?

Head over to the …

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…

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.

At the time of writing, the OpenLampTech developer newsletter is entering its 10th straight month of publishing so I thought it was time to share a ‘Tools of the Trade – …

We are bringing you another issue of OpenLampTech this week with many great curated articles. Enjoy those you like most and please share the publication with others. Thank you so much for reading!

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.

This week in OpenLampTech, we have articles covering:

• MySQL UUIDs
• PHP implode() and explode() functions
• LAMP stack on MySQL HeatWave
• WordPress custom single post template
• And much much more

Head over to the OpenLampTech …

The INFORMATION_SCHEMA database is full of information and metadata about your database(s). Columns are a necessity and their definition ensures sound storage and data integrity. Learn all about them with the COLUMNS table.

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.

Image by Gerd Altmann from  …

I can’t thank you all enough for making OpenLampTech a successful endeavor for me. We are continuing to publish great newsletters that get read and draw in new subscribers. This week’s issue is loaded with great content so enjoy those articles you like most. Please share with others…

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.

In OpenLampTech issue #43 we have content on:

• The PHP Constructor
• WordPress needs writing
• MySQL Window Functions
• Managing 1,300 WordPress sites
• A list of great free …

Of course, there are other ways to determine what tables are present in a particular MySQL Database or Schema. You can also find this information if your database user account has permissions for the INFORMATION_SCHEMA database. Continue reading and follow along with an example query…

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.

Image by Clker-Free-Vector-Images from  …

The OpenLampTech publication is entering its 9th month of publishing and I have you to thank. OpenLampTech continues to grow. Thank you! We have several great articles this week. Enjoy and share with others.

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.

In OpenLampTech issue #40 we have articles covering:

• The SQL NULL
• Custom helper functions in CodeIgniter 4
• PHP built-in web server
• MySQL command line
• And much much more

Be sure and head over to the …