PyMongo Basic Queries Step by Step for Beginners

Learn basic PyMongo queries with simple examples like insert, find, update, delete, count, sort, and limit.

Introduction

PyMongo is the official Python library used to connect Python with MongoDB.

Step 1: Import PyMongo

from pymongo import MongoClient

Step 2: Connect to MongoDB

client = MongoClient("mongodb://localhost:27017/")

Step 3: Create Database

db = client["college"]

Step 4: Create Collection

students = db["students"]

Step 5: Insert One Document

students.insert_one({
    "name": "Harsh",
    "course": "BCA",
    "age": 22
})

Step 6: Insert Multiple Documents

students.insert_many([
    {"name": "Rahul", "course": "BCA", "age": 21},
    {"name": "Priya", "course": "MCA", "age": 23},
    {"name": "Aman", "course": "B.Tech", "age": 24}
])

Step 7: Find One Document

students.find_one()

Step 8: Find All Documents

for student in students.find():
    print(student)

Step 9: Find Specific Data

students.find({"course": "BCA"})

Step 10: Comparison Queries

Greater Than

students.find({"age": {"$gt": 21}})

Less Than

students.find({"age": {"$lt": 23}})

Greater Than Equal

students.find({"age": {"$gte": 22}})

Less Than Equal

students.find({"age": {"$lte": 23}})

Step 11: Use $in Operator

students.find({"course": {"$in": ["BCA", "MCA"]}})

Step 12: Update One Document

students.update_one(
    {"name": "Harsh"},
    {"$set": {"age": 23}}
)

Step 13: Update Multiple Documents

students.update_many(
    {"course": "BCA"},
    {"$set": {"status": "Active"}}
)

Step 14: Delete One Document

students.delete_one({"name": "Aman"})

Step 15: Delete Multiple Documents

students.delete_many({"course": "MCA"})

Step 16: Count Documents

students.count_documents({})

Step 17: Sort Documents

students.find().sort("age", 1)

students.find().sort("age", -1)

Step 18: Limit Results

students.find().limit(2)

Common PyMongo Query Methods

Method	Purpose
insert_one()	Insert one document
insert_many()	Insert multiple documents
find()	Retrieve all documents
find_one()	Retrieve one document
update_one()	Update one document
update_many()	Update many documents
delete_one()	Delete one document
delete_many()	Delete multiple documents
count_documents()	Count records
sort()	Sort data
limit()	Limit results

Conclusion

PyMongo makes it simple to work with MongoDB using Python.

Creating records
Reading records
Updating records
Deleting records

PyMongo Basic Queries Step by Step for Beginners | Complete PyMongo Tutorial