MongoDB - Step by Step Basics of Query Insert Update Delete CRUD Operations

BASICS 1) Create the Database a. use SoccerLeague 2) Create a Table (Collections) a. db.createCollection("Teams") or just save an item into DB 3) List the Collections (tables) within a DB a. show collections 4) Drop a Collection (table) within a DB a. db.Teams.drop(); 5) Insert Data into the Collection a. a = {"name":"New York Giants", "conference": "American"} b. db.Teams.save(a); 6) Query Data from the Collection a. db.Teams.find({"name":"New York Giants"}); b. db.Teams.find({"name":"Yankees"}); 7) Multiple Update a document (row) within a Collection a. db.Teams.update({"name":"New York Giants"}, {"name":"New York Jets"}, {multi: true}); 8) Single Update a document (row) within a Collection a. db.Teams.update({ _id:1001, "name":"New York Giants"}); 9) Remove a document (row) within a Collection a. db.Teams.remove({ _id:1001}); 10) Bulk Load or Script Data into the Collection a. load("File Relative To initial Current DOS Path") 11) Copy Database a. db.copyDatabase("SoccerLeague", "FootballLeague", "localhost")