본문 바로가기

공부 기록/Database

MQL, Query Filter, Operator

SQL vs MQL(MongoDB Query Language)

https://www.mongodb.com/docs/manual/reference/sql-comparison/

 

SQL to MongoDB Mapping Chart — MongoDB Manual

Docs Home → MongoDB Manual In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about MongoDB.The following table presents the various SQL terminology and concepts an

www.mongodb.com

 

SELECT * FROM table; <-> db.collection.find()

CREATE TABLE ~ <-> db.createCollection(), 또는 데이터 insert 시 자동으로 컬렉션 생성


Query Filter, Operator

db.collection.find(
    { age: {$gt : 10} }
}

{ age: {$gt : 10} } => Query criteria, Query filter

$gt => Operator

 

https://www.mongodb.com/docs/manual/reference/operator/

 

Operators — MongoDB Manual

Docs Home → MongoDB Manual Query and Projection OperatorsQuery operators provide ways to locate data within the database and projection operators modify how data is presented.Update OperatorsUpdate operators are operators that enable you to modify the da

www.mongodb.com

 

'공부 기록 > Database' 카테고리의 다른 글

Spring Data MongoDB 적용해보기  (0) 2023.06.28
MongoDB CRUD  (0) 2023.06.24
MongoDB 설치하기  (0) 2023.06.23
정렬, 집계 함수, 그룹핑  (0) 2023.06.02
Join  (0) 2023.06.02