mongodb vs mysql
snippet in sql

mongodb vs mysql

user114

'''
MySQL is a relational database management system (RDBMS) from the 
Oracle Corporation. Like other relational systems, MySQL stores data 
in tables and uses structured query language (SQL) for database 
access. When MySQL developers need to access data in an application, 
they merge data from multiple tables together in a process called a 
join. In MySQL, you predefine your database schema and set up rules 
to govern the relationships between fields in your tables.

MongoDB is a NoSQL database that stores data as JSON-like documents. 
Documents store related information together and use the MongoDB 
query language (MQL) for access. Fields can vary from document to 
document - there is no need to declare the structure of documents to 
the system, as documents are self-describing. Optionally, schema 
validation can be used to enforce data governance controls over each 
collection.
'''

mongodb comparison

user6155

Name	Description
$eq		Matches values that are equal to a specified value.
$gt		Matches values that are greater than a specified value.
$gte	Matches values that are greater than or equal to a specified value.
$in		Matches any of the values specified in an array.
$lt		Matches values that are less than a specified value.
$lte	Matches values that are less than or equal to a specified value.
$ne		Matches all values that are not equal to a specified value.
$nin	Matches none of the values specified in an array.