This guide is a short form of MongoDB and MySQL Compared from mongoDB
db.users.insert({
user_id: 'bcd001',
age: 45,
status: 'A'
})
INSERT INTO users (user_id, age, status)
VALUES ('bcd001', 45, 'A')
db.user.find()
SELECT * FROM users
If the user is older then 25 we want his status to be 'C'.
db.users.update(
{ age: { $gt: 25 } },
{ $set: { status: 'C' } },
{ multi: true }
)
UPDATE users SET status = 'C'
WHERE age > 25
Optional Homework:
https://www.youtube.com/watch?v=rRoy6I4gKWU