Remove by id in MongoDB console

Question

In the MongoDB console how can I remove a record by id  Here s my collection                  id        oid     4d512b45cc9374271b02ec4f           name     Gazza                  id        oid     4d513345cc9374271b02ec6c           name     Dave         adminOf               email     email email com          And here are the commands I ve tried that don t work    db test users remove     id     oid  new ObjectId  4d512b45cc9374271b02ec4f       db test users remove     id     oid   4d513345cc9374271b02ec6c      db test users remove     id   4d512b45cc9374271b02ec4f     db test users remove     id  new ObjectId  4d512b45cc9374271b02ec4f        Removing by name works    db test users remove    name   Gazza       This is in the browser shell on at mongodb org if that makes any difference  Thanks

User · Answer

Well  the  id is an object in your example  so you just need to pass an object   db test users remove    id       oid     4d513345cc9374271b02ec6c         This should work  Edit  Added trailing paren to ensure that it compiled

User · Answer

Solution and Example   1- C  MongoDB Server 3 2 bin mongo  do not issue command yet because you are not connected to any database yet  you are only connected to database server mongodb    2-      show dbs   analytics database  0 000GB   local               0 000GB   test database       0 000GB   3-      use test database   switched to db test database   4-     db Collection remove    id   ObjectId  5694a3590f6d451c1500002e     1     WriteResult    nRemoved    1      now you see WriteResult    nRemoved    1    is 1 not 0   Done

User · Answer

db collection  quot collection name quot   deleteOne   id ObjectId  quot 4d513345cc9374271b02ec6c quot

User · Answer

Even though this post is outdated  collection remove is deprecated  collection delete one should be used instead   More information can be found here under  remove

User · Answer

I ve just bumped into this myself and this variation worked for me   db foo remove     id    new ObjectId  4f872685a64eed5a980ca536

User · Answer

The answer is that the web console shell at mongodb org behaves differently and not as I expected it to  An installed version at home worked perfectly without problem ie  the auto generated  id on the web shell was saved like this      id        oid     4d512b45cc9374271b02ec4f       The same document setup at home and the auto generated  id was saved like this      id    ObjectId  4d5192665777000000005490     Queries worked against the latter without problem

User · Answer

Do you have multiple mongodb nodes in a replica set   I found  I am using via Robomongo gui mongo shell  I guess same applies in other cases  that the correct remove syntax  i e   db test users remove    id   ObjectId  4d512b45cc9374271b02ec4f          does not work unless you are connected to the primary node of the replica set

User · Answer

first get the ObjectID function from the mongodb ObjectId   require mongodb  ObjectID   then you can call the  id with the delete function    id    ObjectId  4d5192665777000000005490

User · Answer

Very close  This will work   db test users deleteOne     id   ObjectId  4d512b45cc9374271b02ec4f        i e  you don t need a new for the ObjectId   Also  note that in some drivers tools  remove   is now deprecated and deleteOne or deleteMany should be used instead

User · Answer

Suppose we have this dummy collection       id    ObjectId  5ea53fedaa79db20d4e14284     item     planner    qty    75     simply use   db inventory deleteOne    id  ObjectId  5ea53fedaa79db20d4e14284        it will be deleted with this as a response      acknowledged    true   deletedCount    1     Thats it

User · Answer

If you would like to remove by a list of IDs this works great    db CollectionName remove         id              in                ObjectId  0930292929292929292929                ObjectId  0920292929292929292929

[mongodb] Remove by _id in MongoDB console

Examples related to mongodb