updating & deleting

deletes.js

db.sales.deleteOne({_id: ObjectId("5bd761dcae323e45a93ccff1")})
db.sales.deleteMany({ storeLocation: {$in: [ 'Denver', 'New York' ]} });
db.sales.deleteMany({})

deletes.sql

DELETE FROM sales WHERE id = '1234567';
DELETE FROM sales WHERE storeLocation IN ('Denver', 'New York');
DELETE FROM sales;

updates.js

db.sales.updateOne(
  { _id: ObjectId("5bd761dcae323e45a93ccff1") },
  { $set: { storeLocation: "London" } }
);

db.sales.updateMany(
  { purchaseMethod: "Online" },
  { $set: { couponUsed: true } }
);

updates.sql

UPDATE sales SET storeLocation = 'London' WHERE id = '1234567';
UPDATE sales SET couponUsed = true WHERE purchaseMethod = 'Online';