MySQL VS MongoDB 쿼리 유형 비교

 

# 입력
INSERT INTO users (id, name, department) VALUES (1001, '김철수', '컴퓨터')

db.users.insertOne({
    id: 1001,
    name: "김철수",
    department: "컴퓨터"
})


# 조회
SELECT * FROM users WHERE department = "컴퓨터";

db.users.find({
    department: "컴퓨터"
})


# 업데이트
UPDATE users SET department = "TEST" WHERE id = 1001;

db.users.updateOne({id: 1001}, {$set: {department:"TEST"}})


# 조인
SELECT s.name, g.course FROM users AS s JOIN grades ON s.id = grades.users_id WHERE s.name = "김철수";

db.users.find({name: "김철수"}, {name: 1, grades.course : 1})