Create collection(table) and insert document(rows) in Mongodb

Create collection(table) and insert document(rows) in Mongodb

Create the table and insert data into the MongoDB. Following are the steps for MongoDB:

1. Check the db which is connected.

db

2. Connect with mydb database

use mydb

3. Create two documents named j and k by using the following sequence of javascript

j = {name:"RAM"}
k = {address:"delhi"}
i = {x:3}

4. Insert the  j, k and i into the collection name employee

db.employee.insert(j)
db.employee.insert(k)
db.employee.insert(i)

5. Check the collection exists

show collections

6. confirm the document insert into the collection

db.employee.find()

Example

-- Switch to the DB
> use mydb
switched to db mydb

-- Show all db present
> show dbs
admin  (empty)
local  0.078GB
test   (empty)

-- Assigned value
> j={name:"RAM"}
{ "name" : "RAM" }
> k={address:"Delhi"}
{ "address" : "Delhi" }
> i={empno:10}
{ "empno" : 10 }

-- Insert data into collection
> db.employee.insert(j)
WriteResult({ "nInserted" : 1 })
> db.employee.insert(k)
WriteResult({ "nInserted" : 1 })
> db.employee.insert(i)
WriteResult({ "nInserted" : 1 })

--Check collection present in DB
> show collections
employee
system.indexes

--Run Select query for fetch inserted data
> db.employee.find()
{ "_id" : ObjectId("540eb24efbf4b1a1447adde9"), "name" : "RAM" }
{ "_id" : ObjectId("540eb25ffbf4b1a1447addea"), "address" : "Delhi" }
{ "_id" : ObjectId("540eb267fbf4b1a1447addeb"), "empno" : 10 }

--Check databases
> show dbs
admin  (empty)
local  0.078GB
mydb   0.078GB
test   (empty)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.