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…)Database
OpenLampTech issue #44 – Substack Repost
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!
(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…)MySQL WHERE Clause Conditional With Numeric Data
We know that when filtering text data in a MySQL WHERE clause conditional, strings are placed in single quotes. In this blog post, learn how to filter numeric data in a MySQL WHERE clause conditional…
(more…)