a crud comparison between SQL and NoSQL
Flyfish 2015-7-21
Create, Read, Update and Delete (CRUD)
SQL mode
Check
Select Column name from table name select * FROM table name select Column name from table name WHERE column operator value
Increase
INSERT into table name values (value 1, value 2,....) INSERT into table_name (column 1, column 2,...) Values (value 1, value 2,....)
Delete
DELETE from table name WHERE column name = value
Change
UPDATE table name SET column name = new value WHERE Column name = value
NoSQL mode (MongoDB)
Check
Db.collection.find (query, projection) db.products.find ({qty: {$gt: 25}})
Increase
Db.collection.insert () Db.products.insert ({item: "Card", qty:15})
Delete
Db.collection.remove () db.products.remove ({qty: {$gt: 20}})
Change
Db.collection.update (query, update, Options) Db.people.update ( {name: "Andy"}, { name: "Andy", Rating:1, score:1 }, {upsert:true})
Compare
SELECT * from the users WHERE age=18db.users.find ({age:18}) INSERT into Users VALUES (' SSS ', *) Db.users.insert ({name: ' SSS '), AGE:18}) UPDATE users SET age=18 WHERE name= ' sss ' db.users.update ({name: ' SSS '}, {$set: {age:18}}, False, True) DELETE from U Sers WHERE age=18db.users.remove ({age:18});
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
A crud comparison between SQL and NoSQL