How to update the _id of a MongoDB document?-MongoDB-php.cn

How to update the _id of a MongoDB document?

WBOY

Release： 2023-08-31 22:29:02

forward

1600 people have browsed it

如何更新 MongoDB 文档的 _id？

You can't update it, but you can save the new ID and delete the old one. Follow some steps to update MongoDB's _id. The steps are as follows:

Step 1: In the first step, the ObjectId needs to be stored in a variable.

anyVariableName=db.yourCollectionName.findOne({_id:yourObjectIdValue)});

Copy after login

Step 2: In the second step, you need to set a new id.

yourDeclaredVariableName._id=yourNewObjectIdValue;

Copy after login

Step 3: In the third step, you need to insert the new ID in the document.

db.yourCollectionName.insert(yourDeclaredVariableName);

Copy after login

Step 4: In the fourth step, you need to delete the old ID.

db.yourCollectionName.remove({_id:yourOldObjectIdValue)});

Copy after login

To understand the above steps, let us create a collection with documents. The query to create a collection using documents is as follows:

> db.updateIdDemo.insertOne({"StudentName":"Robert"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5c6ebfec6fd07954a4890683")
}
> db.updateIdDemo.insertOne({"StudentName":"Chris"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5c6ebff66fd07954a4890684")
}
> db.updateIdDemo.insertOne({"StudentName":"Maxwell"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5c6ebfff6fd07954a4890685")
}

Copy after login

Display all documents in the collection with the help of find() method. The query is as follows:

> db.updateIdDemo.find().pretty();

Copy after login

The following is the output:

{ "_id" : ObjectId("5c6ebfec6fd07954a4890683"), "StudentName" : "Robert" }
{ "_id" : ObjectId("5c6ebff66fd07954a4890684"), "StudentName" : "Chris" }
{ "_id" : ObjectId("5c6ebfff6fd07954a4890685"), "StudentName" : "Maxwell" }

Copy after login

The following is the query to update the _id of a MongoDB document:

Step1:
> myId=db.updateIdDemo.findOne({_id:ObjectId("5c6ebfec6fd07954a4890683")});
{ "_id" : ObjectId("5c6ebfec6fd07954a4890683"), "StudentName" : "Robert" }

Step 2:
> myId._id=ObjectId("5c6ebfec6fd07954a4890689");
ObjectId("5c6ebfec6fd07954a4890689")

Step 3:
> db.updateIdDemo.insert(myId);
WriteResult({ "nInserted" : 1 })

Step 4:
> db.updateIdDemo.remove({_id:ObjectId("5c6ebfec6fd07954a4890683")});
WriteResult({ "nRemoved" : 1 })

Copy after login

Let us check if the _id has been updated. Display all documents in the collection with the help of find() method:

> db.updateIdDemo.find().pretty();

Copy after login

The following is the output:

{ "_id" : ObjectId("5c6ebff66fd07954a4890684"), "StudentName" : "Chris" }
{ "_id" : ObjectId("5c6ebfff6fd07954a4890685"), "StudentName" : "Maxwell" }
{ "_id" : ObjectId("5c6ebfec6fd07954a4890689"), "StudentName" : "Robert" }

Copy after login

View the sample output, "StudentName":_id of "Robert" corrected.

The above is the detailed content of How to update the _id of a MongoDB document?. For more information, please follow other related articles on the PHP Chinese website!