Tuesday, November 15, 2016

DDL/DML statements


(1) Insert record:

db.players.insert(
{
        "position" : "Center",
        "id" : 8474091,
        "weight" : 190,
        "height" : "6' 3\"",
        "imageUrl" : "http://1.cdn.nhle.com/photos/mugs/8474091.jpg",
        "birthplace" : "Huntington, NY, USA",
        "age" : 26,
        "name" : "Brandon Sutter",
        "birthdate" : "February 14, 1989",
        "number" : 16
}
)


Insert nested records
--------------------------
Nested Records

db.users.insert(
{
_id:"123",
name:"Hassan Bob",
addresses:[
{
street:"151, South Locust Dr",
city:"Hartford",
state:"CT",
postal:"49949"
},
{
street:"15, Garden Dr",
city:"Liverpool",
state:"NY",
postal:"13088"
}
]
}
)

===============

db.users.insert(
{
   _id: "joe",
   name: "Joe Bookreader"
}

{
   patron_id: "joe",
   street: "123 Fake Street",
   city: "Faketon",
   state: "MA",
   zip: "12345"
}

{
   patron_id: "joe",
   street: "1 Some Other Street",
   city: "Boston",
   state: "MA",
   zip: "12345"
}
)





(2) Update record:

db.players.update(
 {
 "_id" : ObjectId("582b7c5fa784f623f13106eb")},
 {
         "position" : "Left Wing",
         "id" : 8465166,
         "weight" : 180,
         "height" : "6' 0\"",
         "imageUrl" : "http://1.cdn.nhle.com/photos/mugs/8465166.jpg",
         "birthplace" : "Seria, BRN",
         "age" : 37,
         "name" : "Raza mohamed",
         "birthdate" : "April 26, 1977",
         "number" : 27
 }
 )

(3) Remove record/delete command:

db.players.remove(
{"_id" : ObjectId("582b86fca784f623f13106ee")
}
)


(4) Drop Collection:
===============
db.players.drop()

No comments:

Post a Comment