Episode-010 – UNION, INTERSECT, and EXCEPT in MySQL

This video demonstrates how UNION, INTERSECT, and EXCEPT work when retrieving data from a MySQL database.

MySQL Shell – https://dev.mysql.com/doc/mysql-shell/8.0/en/

UNION Documentation – https://dev.mysql.com/doc/refman/8.0/en/union.html

INTERSECT Documentation – https://dev.mysql.com/doc/refman/8.0/en/intersect.html

EXCEPT Documentation – https://dev.mysql.com/doc/refman/8.0/en/except.html

Code and Data Used in Video – https://github.com/boyzoid/mysql-shorts/tree/main/010