ล้าง Array Field ให้ว่างด้วย $set: []
db.yourCollectionName.update({}, { $set : {"yourFieldName": [] }} , {multi:true} );
สร้างข้อมูลตัวอย่าง
> db.deleteAllElementsInArrayDemo.insertOne({"InstructorName":"Larry","InstructorTechnicalSubject":["Java","MongoDB"]});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8fb971d3c9d04998abf00e") }
> db.deleteAllElementsInArrayDemo.insertOne({"InstructorName":"Mike","InstructorTechnicalSubject":["C","C++","Python"]});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8fb98ad3c9d04998abf00f") }
ลบ Element ทั้งหมดใน Array (Multi Update)
> db.deleteAllElementsInArrayDemo.update({}, { $set : {"InstructorTechnicalSubject": [] }} , {multi:true} );
WriteResult({ "nMatched" : 2, "nUpserted" : 0, "nModified" : 2 })
ตรวจสอบผลลัพธ์
> db.deleteAllElementsInArrayDemo.find().pretty();
{ "_id" : ObjectId("5c8fb971d3c9d04998abf00e"), "InstructorName" : "Larry", "InstructorTechnicalSubject" : [ ] }
{ "_id" : ObjectId("5c8fb98ad3c9d04998abf00f"), "InstructorName" : "Mike", "InstructorTechnicalSubject" : [ ] }
Array Field "InstructorTechnicalSubject" ของทุก Document ถูกตั้งค่าเป็น Array ว่าง []