Multilingual MariaDB video on Set Theory Features

Our very own Ian Gilfillan has created a brief and clear video called Get Set for Set Theory: UNION, INTERSECT and EXCEPT in SQL


Get Set for Set Theory: UNION, INTERSECT and EXCEPT in SQL

In a tad more than six minutes, you’ll see exactly how UNION, INTERSECT and EXCEPT work, starting in MariaDB 10.3, a few years back.

Ian explains what they are for, and the option to change default behaviour of DISTINCT with ALL (of which the ALL option was introduced in MariaDB 10.5).

That’s not new.

Read more