content_image/684547.jpg content_image/684566.jpg
For more information, see db.collection.find() , db.collection.distinct() , db.collection.findOne() , $ne $and , $or , $gt , $lt , $exists , $lte , $regex , limit() , skip() , explain() , sort() , and count() . 

Update Records The following table presents the various SQL statements related to updating existing records in tables and the corresponding MongoDB statements. 

<img src='content_image/684547.jpg'>

For more information, see db.collection.update() , $set , $inc , and $gt . 

Delete Records The following table presents the various SQL statements related to deleting records from tables and the corresponding MongoDB statements. 

<img src='content_image/684566.jpg'>

For more information, see db.collection.remove() . 

## Additional Resources 

• Transitioning from SQL to MongoDB (Presentation) 16 

• Best Practices for Migrating from RDBMS to MongoDB (Webinar) 17 

• SQL vs. MongoDB Day 1-2 18 

• SQL vs. MongoDB Day 3-5 19 

• MongoDB vs. SQL Day 14 20 

• MongoDB and MySQL Compared 21 

