In MariaDB, the MINUS operator returns distinct rows from the left input query that aren’t output by the right input query.
The MINUS operator was introduced in MariaDB 10.6.1 as a synonym for the EXCEPT operator for the purposes of compatibility with Oracle. Therefore, we can use MINUS and EXCEPT interchangeably (in MariaDB 10.6.1 and later).
In MariaDB, the UNION operator combines the results from multiple SELECT statements into a single result set.
In MariaDB, the INTERSECT operator intersects two queries and returns only those rows that are returned in both queries.
It returns all rows from the left SELECT result set that are also present in the right SELECT result set.
In MariaDB, the EXCEPT operator returns rows from the left input query that aren’t output by the right input query.
Another way of putting it is that it returns all rows from the left SELECT result set except rows that are in right SELECT result set.
MySQL supports the use of the pipe concatenation operator (||) for concatenating its operands. However, you need to enable it first.
This article lists the various aggregation pipeline operators that can be used to return individual date parts from a Date object in MongoDB.
Continue readingMongoDB’s aggregation pipeline framework includes a $round operator and a $trunc operator. These operators perform similar, but different tasks.
MongoDB includes the $strLenBytes and $strLenCP operators in its aggregation pipeline framework. These operators do a similar but slightly different thing. In some cases, both will return exactly the same result, while in other cases the results will differ.
Here’s a quick overview of the difference between these two operators.
Continue readingIf you need to return the size of a document in MongoDB, you can use the following:
$bsonSize aggregation pipeline operatorObject.bsonSize() methodBelow are examples of each approach.
Continue readingIn MariaDB, DIV performs integer division.
It discards from the division result any fractional part to the right of the decimal point.
Continue reading