In MariaDB, the UNION operator combines the results from multiple SELECT statements into a single result set.
operators
MariaDB INTERSECT Operator Explained
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.
MariaDB EXCEPT Operator Explained
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.
How to Enable the Pipe Concatenation Operator in MySQL
MySQL supports the use of the pipe concatenation operator (||) for concatenating its operands. However, you need to enable it first.
MongoDB Aggregation Operators for Returning Date Parts
This article lists the various aggregation pipeline operators that can be used to return individual date parts from a Date object in MongoDB.
$strLenBytes vs $strLenCP in MongoDB: What’s the Difference?
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.
2 Ways to Get a Document’s Size in MongoDB
If you need to return the size of a document in MongoDB, you can use the following:
- The
$bsonSizeaggregation pipeline operator - The
Object.bsonSize()method
Below are examples of each approach.
How DIV Works in MariaDB
In MariaDB, DIV performs integer division.
It discards from the division result any fractional part to the right of the decimal point.
How the Modulo Operator Works in MariaDB
In MariaDB, the modulo operator (%) returns the modulo operation. It returns the remainder of its first argument divided by its second argument.