Database.Guide

Skip to content

Beginners

  • What is a Database?
  • Database Tutorial

SQL

  • SQL Tutorial
  • SQL Reference
  • SQL Joins Tutorial
  • SQL Transactions Tutorial
  • Basic SQL Queries

Categories

  • Azure SQL Edge (17)
  • Database Concepts (99)
  • Database Tools (72)
  • DBMS (9)
  • DuckDB (161)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,170)
  • SQLite (299)

Tag: what is

MongoDB $subtract

Posted on February 21, 2021February 21, 2021 by Ian

In MongoDB, you can use the $subtract aggregation pipeline operator to subtract numbers and/or dates.

idickson
MongoDB aggregation, operators, what is

MongoDB $add

Posted on February 21, 2021February 21, 2021 by Ian

In MongoDB, the $add aggregation pipeline operator adds values together. Such values can be numbers, or they can be numbers and a date.

The $add operator accepts the values as arguments. The arguments can be any valid expression as long as they resolve to either all numbers or to numbers and a date.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $anyElementTrue

Posted on February 20, 2021February 20, 2021 by Ian

In MongoDB, the $anyElementTrue aggregation pipeline operator evaluates an array as a set and returns true if any of the elements are true.

If none of the elements is true, then it returns false.

An array’s element is true if it’s not false, null, 0, or undefined.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $allElementsTrue

Posted on February 20, 2021February 20, 2021 by Ian

In MongoDB, the $allElementsTrue aggregation pipeline operator evaluates an array as a set and returns true if no element in the array is false.

If the array contains an element that is false, then $allElementsTrue returns false.

An array’s element is true if it’s not false, null, 0, or undefined.

Continue reading →
MongoDB aggregation, operators, what is

About the GO Command in SQL Server

Posted on February 17, 2021February 17, 2021 by Ian

If you’ve used T-SQL you will probably be familiar with the GO command. This command is often placed at the end of a batch of statements.

Continue reading →
SQL Server mssql, t-sql, what is

MongoDB $push vs $addToSet: What’s the Difference?

Posted on February 14, 2021February 14, 2021 by Ian

MongoDB has a $push operator and an $addToSet operator, both of which do a very similar thing.

Both operators append values to an existing array. The main difference is in how they deal with arrays that already contain the value you’re trying to append, and also in the modifiers that can be used.

Continue reading →
MongoDB what is

MongoDB $toUpper

Posted on February 7, 2021February 7, 2021 by Ian

In MongoDB, the $toUpper aggregation pipeline operator converts a string to uppercase and returns the result.

Continue reading →
MongoDB aggregation, convert, operators, what is

MongoDB $toLower

Posted on February 7, 2021February 7, 2021 by Ian

In MongoDB, the $toLower aggregation pipeline operator converts a string to lowercase and returns the result.

Continue reading →
MongoDB aggregation, convert, operators, what is

MongoDB $exists

Posted on February 6, 2021February 6, 2021 by Ian

In MongoDB, you can use the $exists element query operator to match documents that contain a specific field.

You can also use it to match documents that don’t contain a specific field.

You can also use it in conjunction with other operators such $nin to match documents where a given field exists, but it doesn’t contain a specific value.

Continue reading →
MongoDB operators, what is

MongoDB forEach()

Posted on February 6, 2021February 6, 2021 by Ian

In MongoDB, the cursor.forEach() method iterates the cursor to apply a JavaScript function to each document from the cursor.

Continue reading →
MongoDB methods, what is
  • «
  • 1
  • …
  • 119
  • 120
  • 121
  • 122
  • 123
  • …
  • 151
  • »

About Database.Guide | Privacy Policy