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…
(more…)Database Programming
How To Combine Window Functions in MySQL
Window Functions operate on groups of rows, returning a value for every row in the group, unlike Aggregate Functions which collapse rows into a single value. With the many different Window Functions available, can you combine them at the same level? Learn more in this article.
(more…)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…)