Short MongoDB vs MySQL query syntax

Battle of the Giants.md

Battle of the Giants

This guide is a short form of MongoDB and MySQL Compared from mongoDB

• Battle of the Giants
  • Inserting user with (id, age, status)
    • MongoDB
    • MySQL
  • Get all Users
    • MongoDB
    • MySQL
  • Update user based on age
    • MongoDB
    • MySQL

Inserting user with (id, age, status)

MongoDB

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

MySQL

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

Get all Users

MongoDB

db.user.find()

MySQL

SELECT * FROM users

Update user based on age

If the user is older then 25 we want his status to be 'C'.

MongoDB

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

MySQL

UPDATE users SET status = 'C'
WHERE age > 25

More things about:

SQL:

https://www.codeschool.com/courses/try-sql

MongoDB:

https://university.mongodb.com/