I have two fields in my User Scehma , cart and orders both are array.

I want to copy all the items in cart array to orders array and then remove/delete all the items in my cart array. How do I that ?

CodePudding user response：

use update $set with $concatArrays

db.collection.update({},
[
  {
    $set: {
      orders: {
        $concatArrays: [
          "$orders",
          "$carts"
        ]
      },
      carts: []
    }
  }
])

mongoplayground