方法 说明 语法
新增 MongoDB db.getCollection(‘user’).insert({“userId” : “014”,”uclass” : “B”,”name” : “Back”,”age” : 11,”email” : “b14@sina.com“,”birthday” : ISODate(“2018-07-31T03:46:13.885Z”),”dataStatus” : 1});
MySQL INSERT INTO sz-temp.user (userId, uclass, name, age, email, birthday, dataStatus) VALUES (‘014’, ‘B’, ‘Back13’, ‘20’, ‘b14@sina.com‘, ‘2013-07-31 11:46:13’, ‘0’);
方法 说明 语法
删除 MongoDB db.getCollection(‘user’).remove({“userId”:”014”});
MySQL delete from user where userId = ‘014’;
方法 说明 语法
修改 MongoDB db.getCollection(‘user’).update({“userId”:”013”}, {$set:{“email”:”b13@sina.com“, “age”:20}});
MySQL update user set email = ‘b13@sina.com‘, age = 20 where userId = ‘013’;
方法 说明 语法
查询所有 MongoDB db.getCollection(‘user’).find({});
MySQL select * from user;
查询条件：= MongoDB db.getCollection(‘user’).find({“age”:16});等效于db.getCollection(‘user’).find({“age”:{$eq:16}});
MySQL select * from user where age = 16;
查询条件：like MongoDB db.getCollection(‘user’).find({“name”:/Ba/});
MySQL select * from user where name like ‘%Ba%’;
查询条件：distinct MongoDB db.getCollection(‘user’).distinct(“name”);
MySQL select distinct uclass from user u;
查询条件：> MongoDB db.getCollection(‘user’).find({“age”:{$gt:16}});
MySQL select * from user where age >16;
查询条件：>= MongoDB db.getCollection(‘user’).find({“age”:{$gte:16}});
MySQL select * from user where age >= 16;
查询条件：< MongoDB db.getCollection(‘user’).find({“age”:{$lt:16}});
MySQL select * from user where age < 16;
查询条件：<= MongoDB db.getCollection(‘user’).find({“age”:{$lte:16}});
MySQL select * from user where age 16;
查询条件：or MongoDB db.getCollection(‘user’).find({$or:[{“uclass”:”A”},{“class”:”B”}]});
MySQL select * from user where uclass = ‘A’ or uclass = ‘B’;
查询条件：时间 MongoDB db.getCollection(‘user’).find({“birthday”:{$gt: new Date(“2008-08-14T06:24:40.110Z”), $lt: new Date(“2015-08-14T06:14:40.089Z”)}});
MySQL select * from user where birthday > ‘2008-08-14 06:24:40’ and birthday < ‘2015-08-14 06:14:40’;
查询条件：count MongoDB db.getCollection(‘user’).find({“uclass”:”A”}).count();
MySQL select count(1) from user where uclass = ‘A’;
查询条件：sort升序 MongoDB db.getCollection(‘user’).find({}).sort({“age”:1});
MySQL select * from user order by age asc;
查询条件：sort降序 MongoDB db.getCollection(‘user’).find({}).sort({“age”:-1});
MySQL select * from user order by age desc;