Joeyrodrigues92
3/20/2017 - 11:41 PM

sql ---> mongo

sql ---> mongo

sql

INSERT INTO users (user_id, age, status)
VALUES ('bcd001', 45, 'A')

mongo
db.users.insert({
  user_id: 'bcd001',
  age: 45,
  status: 'A'
})

----
sql
SELECT * FROM users

mongo
db.users.find()
---
sql
UPDATE users SET status = 'C'
WHERE age > 25

mongo
db.users.update(
  { age: { $gt: 25 } },
  { $set: { status: 'C' } },
  { multi: true }
)