SQL vs NoSQL Syntax February 22, 2021 totallypix Below is comparison between SQL and NoSQL syntax. For NoSQL here is from MongoDB: SQLMongoDBCREATE TABLE users ( user_id VARCHAR(20) NOT NULL, age INTEGER NOT NULL, status VARCHAR(10));Not RequiredINSERT INTO users(user_id, age, status) VALUES ('bcd001', 45,"A");db.users.insert({ user_id: "bcd001", age: 45, status: "A" })SELECT * FROM users;db.users.find()UPDATE users SET status = 'C' WHERE age > 25;db.users.update( { age: { $gt: 25 } }, { $set: { status: "C" } }, { multi: true } )START TRANSACTION; INSERT INTO orders (order_id, product, quantity) VALUES ('1a2b3c', 'T-shirt', '7'); UPDATE stock SET quantity=quantity-7 WHERE product='T-shirt'; COMMIT;session.startTransaction(); db.orders.insert ({ order_id: '1a2b3c', product: 'T-shirt', quantity: 7 }) db.stock.update ( { product: { $eq: 'T-shirt', } }, { $inc: { quantity: -7 } } }) session.commitTransaction(); Source: https://www.mongodb.com/compare/mongodb-postgresql