MySQL now supports the INTERSECT and EXCEPT set operators. Set operators work on the results of multiple SELECT statements. In this post, we will see example queries using INTERSECT and EXCEPT commands for a better understanding
(more…)SQL
INSERT Using the WITH Clause in MySQL
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…)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…)