一、执行程序的区别 MySQL executable Oracle executable Mongo executable mysqld oracle mongod mysql sqlplus mongo 二、库、表、行、列等概念的区别 MySQL term Mongo term/concept database database table collection index index row BSON document column BSON field join embedding and linking primary key _id field group by aggregation 三、语句用法上的区别 SQL Statement Mongo Statement CREATE TABLE USERS (a Number, b Number) db.createCollection(“mycoll”) ALTER TABLE users ADD … implicit INSERT INTO USERS VALUES(3,5) db.users.insert({a:3,b:5}) SELECT a,b FROM users db.users.find({}, {a:1,b:1}) SELECT * FROM users db.users.find() SELECT * FROM users WHERE……
Continue reading