mongo常用操作(国外英语资料).docVIP

mongo常用操作(国外英语资料) A, query The find method A. collection_name. Query all the results: Select * from users; The db. The users. The find (); Specifies the return of those columns (key) : Select name, skills from users; (1). Note: the first {} place the where condition second {} and specify those columns to display and not display (0 means not displaying 1 for display) Where conditions: The simple thing is: Select name, age, skills from users where name = hurry; age : 1, skills : 1. 2. Use the and Select name, age, skills from users where name = hurry and age = 18; age : age : 1, skills : 1. 3. Use the or Select name, age, skills from users where name = hurry or age = 18; Db. The users. The find ({ $or : [{ name : hurry }, { age: 18}]}, { name : 1, age : 1, skills : 1}); , =, , = ($lt, $lte, $gt, $gte) Select * from users where age = 20 and age = 30; [ age : { age : $lte : $lte : 30}) In, not in ($in, $nin) Select * from users where age in (10, 22, 26); [10, 22] 6. Match the null Select * from users where age is null. A. user.find ({ age : null); Like (mongoDB supports regular expressions) Select * from users where name like % hurry %; (1).user.find ({name: / hurry /}) Select * from users where name like hurry %; Db. The users. The find ({name: / ^ hurry /}); 8. The use of distinct Select distinct (name) from users; A distinct ( name ). 9. The use of the count Select count (*) from users; The db. The users. The count (); The array queries (mongoDBs own unique) If skills are [ Java , python] A. user.find ({ skills : Java}); This statement can match the success $all You must include both Java and python in your skills as well as in your skills size Unfortunately, $size cannot be used in combination with the $lt $slice (1) The two parameters are the offset and the number returned Query the embedded document Powerful $where query Db. Foo. The find (); { _id : ObjectId ( 4e17ce0ac39f1afe0ba78ce4), a : 1, b : 3, c : 10} { _id : ObjectId ( 4e17ce13c39f1afe0ba78ce5), a :