OpenLampTech issue #45 – Substack Repost

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.

(more…)

MySQL Metadata Queries – Column Structure and Definition With the COLUMNS Table

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.

(more…)

OpenLampTech issue #43 – Substack Repost

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…

(more…)

MySQL Metadata Queries – Find all tables in a Schema

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…

(more…)