5 SQL Books – OpenLampTech Repost

There are a variety of content formats you can study to skill up with these days online. I prefer books and other forms of written content with some videos thrown in as well. Interested in a list of books that will help build up your SQL skills? Look no further…

(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…)

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…)