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 .. 2025. 6. 16. MongoDB, RDBMS 구조 비교 MongoDB{ "_id": ObjectId("..."), "student_id": 1001, "name": "김철수", "department": "컴퓨터공학", "enrollment_year": 2020, "grades": [ {"course": "CS101", "grade": "A"}, {"course": "CS102", "grade": "B+"} ]} MySQL 학생 테이블학번이름학과입학년도1001김철수컴퓨터공학20201002이영희경영학2021 성적 테이블학번과목코드학점1001CS101A1001CS102B+1002BZ101A+ 2025. 6. 16. MongoDB 7.0 설치 TL;DR - Install Mac, Ubuntu1. Mac OSbrew tab mongodb/brewbrew install mongodb-community@7.0brew services start mongodb-community@7.0brew services listName Status User Filemongodb-community@7.0 started nhn ~/Library/LaunchAgents/homebrew.mxcl.mongodb-community@7.0.plist mongoshCurrent Mongosh Log ID: 67ff12bbd129c363bc1041e5Connecting to: mongodb://127.0.0.1:27017/?directConne.. 2025. 4. 16. [펌] Redis KEYS vs SCAN 보호되어 있는 글 입니다. 2024. 7. 2. 1장 MySQL과 MariaDB 개요 1장 MySQL과 MariaDB 개요 2023. 12. 21. 이전 1 2 3 4 다음