The publication is growing and we are sharing the good stuff in this OpenLampTech newsletter issue. Developer interviews, a curated WordPress resource, and the LAMP stack coverage you expect are all coming at ya in issue #33…
(more…)Database
MySQL SELECT and WHERE Clause Column Existence
I’m sharing another tip for anyone who wants to learn more about MySQL and how to use it. This post covers an example of the differences in columns specified in the WHERE clause but not the SELECT clause and vice-versa.
(more…)Find All Table’s Current AUTO_INCREMENT Value
I recently wanted to check all tables’ current AUTO_INCREMENT value (if any) for a database dump structure. I wasn’t sure if a tables’ Data Definition Language (DDL) statement contained the current AUTO_INCREMENT value or not. So after I loaded the dump file, I learned of a query to use and find out…
(more…)OpenLampTech issue #31 – Substack Repost
I could barely stuff this week’s OpenLampTech issue #31 into the email client to send out. It is that full! 🤣
(more…)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…)