MONGODB Shell Basic Operations

/opt/mongodb-2.6.6/bin > MONGO

1. Querying all local database names
> Show DBS

2. Switch to the specified database environment (if no database is specified, create a new library)
> Use test;

3. Created a collection called ' EMP '
> db.createcollection (' emp ');
{"OK": 1}

4. Query all clustered collections under the current library collection (equivalent to table)
> Show Collections;
Emp
System.indexes

5. Inserting records
> Db.emp.insert ({' id ': 1, ' name ': ' Tough01 ', ' Age ': 27});
Writeresult ({"ninserted": 1})

Db.emp.insert ({' id ': 1, ' name ': ' Tough1 ', ' Age ': 21});
Db.emp.insert ({' id ': 2, ' name ': ' Tough2 ', ' age ': 22});
Db.emp.insert ({' id ': 3, ' name ': ' Tough3 ', ' age ': 23});
Db.emp.insert ({' id ': 4, ' name ': ' Tough4 ', ' Age ': 24});
Db.emp.insert ({' id ': 5, ' name ': ' Tough5 ', ' Age ': 25});
Db.emp.insert ({' id ': 6, ' name ': ' Tough6 ', ' Age ': 26});
Db.emp.insert ({' id ': 7, ' name ': ' Tough7 ', ' Age ': 27});
Db.emp.insert ({' id ': 8, ' name ': ' Tough8 ', ' Age ': 28});
Db.emp.insert ({' id ': 9, ' name ': ' Tough9 ', ' Age ': 29});

6. Query Operations
1) Query the Row_count of EMP
> Db.emp.count ();
9

2) query the records of id=6
> Db.emp.find ({"id": 6});
{"_id": ObjectId ("548c0acbd6ce26c709fee232"), "id": 6, "name": "Tough6", "Age": 26}

3) Query the records of ID<3 or age>27
> Db.emp.find ({$or: [{id:{$lt: 3}}, {age:{$gt: 27}]});
{"_id": ObjectId ("548c0acbd6ce26c709fee22d"), "id": 1, "name": "Tough1", "Age": 21}
{"_id": ObjectId ("548c0acbd6ce26c709fee22e"), "id": 2, "name": "Tough2", "Age": 22}
{"_id": ObjectId ("548c0acbd6ce26c709fee234"), "id": 8, "name": "Tough8", "Age": 28}
{"_id": ObjectId ("548c0acbd6ce26c709fee235"), "id": 9, "name": "Tough9", "Age": 29}

4) Query Age,name column
> Db.emp.find ({id:{$lt: 7}, age:{$GT: +}}, {age:1, name:1});
{"_id": ObjectId ("548c0acbd6ce26c709fee230"), "name": "Tough4", "Age": 24}
{"_id": ObjectId ("548c0acbd6ce26c709fee231"), "name": "Tough5", "Age": 25}
{"_id": ObjectId ("548c0acbd6ce26c709fee232"), "name": "Tough6", "Age": 26}

5) Query the name contains 5 of the records
> Db.emp.find ({name:/5/});
{"_id": ObjectId ("548c0acbd6ce26c709fee231"), "id": 5, "name": "Tough5", "Age": 25}

6) Query the first 2 records
> Db.emp.find (). limit (2);
{"_id": ObjectId ("548c0acbd6ce26c709fee22d"), "id": 1, "name": "Tough1", "Age": 21}
{"_id": ObjectId ("548c0acbd6ce26c709fee22e"), "id": 2, "name": "Tough2", "Age": 22}

7) Query the first record
> Db.emp.findOne ();
{
"_id": ObjectId ("548c0acbd6ce26c709fee22d"),
"id": 1,
"Name": "Tough1",
"Age": 21
}

8) by age ascending
> Db.emp.find (). Sort ({age:1});
{"_id": ObjectId ("548c0acbd6ce26c709fee22d"), "id": 1, "name": "Tough1", "Age": 21}
{"_id": ObjectId ("548c0acbd6ce26c709fee22e"), "id": 2, "name": "Tough2", "Age": $}
{"_id": ObjectId ("548c0 acbd6ce26c709fee22f ")," id ": 3," name ":" Tough3 "," Age ": $
{" _id ": ObjectId (" 548c0acbd6ce26c709fee230 ")," id ": 4, "name": "Tough4", "Age": $
{"_id": ObjectId ("548c0acbd6ce26c709fee231"), "id": 5, "name": "Tough5", "Age" : +
{"_id": ObjectId ("548c0acbd6ce26c709fee232"), "id": 6, "name": "Tough6", "Age": +}
{"_id": ObjectId ( "548c0acbd6ce26c709fee233"), "id": 7, "name": "Tough7", "Age": +}
{"_id": ObjectId ("548c0acbd6ce26c709fee234"), "id": 8, "name": "Tough8", "Age":--
{"_id": ObjectId ("548c0acbd6ce26c709fee235"), "id": 9, "name": "Tough9", "Age":

9) by age descending
> Db.emp.find (). Sort ({age:-1});
{"_id": ObjectId ("548c0acbd6ce26c709fee235"), "id": 9, "name": "Tough9", "Age": 29}
{"_id": ObjectId ("548c0acbd6ce26c709fee234"), "id": 8, "name": "Tough8", "age":
{"_id": ObjectId ("548c0 acbd6ce26c709fee233 ")," id ": 7," name ":" Tough7 "," Age ": +}
{" _id ": ObjectId (" 548c0acbd6ce26c709fee232 ")," id ": 6, "name": "Tough6", "Age": +}
{"_id": ObjectId ("548c0acbd6ce26c709fee231"), "id": 5, "name": "Tough5", "Age" : +
{"_id": ObjectId ("548c0acbd6ce26c709fee230"), "id": 4, "name": "Tough4", "age": +
{"_id": ObjectId ( "548c0acbd6ce26c709fee22f"), "id": 3, "name": "Tough3", "Age": +}
{"_id": ObjectId ("548c0acbd6ce26c709fee22e"), "id": 2, "name": "Tough2", "Age": $
{"_id": ObjectId ("548c0acbd6ce26c709fee22d"), "id": 1, "name": "Tough1", "Age": +/-

7. Modify the operation
Modify the name of the id=1 record to ' Fox '.
> db.emp.update ({id:1},{$set: {name: ' Fox '}}, False, True);
Writeresult ({"nmatched": 1, "nupserted": 0, "nmodified": 1})

> Db.emp.find ({id:1});
{"_id": ObjectId ("548c0acbd6ce26c709fee22d"), "id": 1, "name": "Fox", "Age": 21}

Db.collection.update (criteria, objnew, Upsert, Multi)
Criteria:update query conditions, similar to those in the SQL update query
Objnew:update objects and some updated operators (such as $, $inc ... ) can also be understood as the SQL update query within the set after the
Upsert: If there is no record of update, insert objnew,true as INSERT, default is False, do not insert.
Multi:mongodb default is False, only update the first record found, if this parameter is true, the condition is checked out all the records are updated.

8. Delete operation
Delete the id=9 record.
> Db.emp.remove ({id:9});
Writeresult ({"nremoved": 1})

> Db.emp.find ();
{"_id": ObjectId ("548c0acbd6ce26c709fee22d"), "id": 1, "name": "Fox", "Age": 21}
{"_id": ObjectId ("548c0acbd6ce26c709fee22e"), "id": 2, "name": "Tough2", "Age": 22}
{"_id": ObjectId ("548c0acbd6ce26c709fee22f"), "id": 3, "name": "Tough3", "Age": 23}
{"_id": ObjectId ("548c0acbd6ce26c709fee230"), "id": 4, "name": "Tough4", "Age": 24}
{"_id": ObjectId ("548c0acbd6ce26c709fee231"), "id": 5, "name": "Tough5", "Age": 25}
{"_id": ObjectId ("548c0acbd6ce26c709fee232"), "id": 6, "name": "Tough6", "Age": 26}
{"_id": ObjectId ("548c0acbd6ce26c709fee233"), "id": 7, "name": "Tough7", "Age": 27}
{"_id": ObjectId ("548c0acbd6ce26c709fee234"), "id": 8, "name": "Tough8", "Age": 28}

9. Renaming a Collection
> db.emp.renameCollection (' test_emp ');
{"OK": 1}

10. Deleting a collection
> Db.test_emp.drop ();
True

> Show Collections;
System.indexes

MONGODB Shell Basic Operations