Home
About
Blog
Products
Forum
Support
Contact
Sunbelt Computer Software
PL/B Language Development and Support
Home
About
Blog
Products
Forum
Support
Contact
MongoDB/MongoDB_CRUD.sql at master · unidev39/MongoDB · GitHub
Skip to content
Navigation Menu
Sign in
Products
Platform
GitHub
Repository hosting, code review, and collaboration
Copilot
AI coding agent for tasks, projects and automated work
Build & Ship
Actions
CI/CD and automation
Code Quality
Quality analysis, fixes, and enforcement
Codespaces
Cloud development environments
Secure
Code Security
Vulnerability detection and remediation
Secret Protection
Secret scanning and leak prevention
All Features
Developers
Learn
Documentation
Training
Certifications
Build
Build with Copilot
Customize Copilot
Integrations
Explore
Trending repos
GitHub Sponsors
Events
Changelog
Changelog
Your source for the latest features, improvements, and fixes across GitHub products, all in one place.
Businesses
By Stage
Enterprises
Team
Startups
Nonprofits
By Industry
Healthcare
Financial services
Manufacturing
Government
See all industries
Evaluate GitHub
Why GitHub
Customer Stories
Business insights
Trust Center
Add-ons
GitHub Advanced Security
Enterprise-grade code security
Copilot for business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Resources
Learn & Connect
Documentation
Resource center
Blog
Events & webinars
Community Forum
Customer Stories
Integrations
Support
Customer support
Training
GitHub Status
Company
About
Partners
Changelog
GitHub Universe
GitHub Universe
The event for developers, by developers — talks, workshops, and what’s next for GitHub.
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
unidev39
MongoDB
Repository navigation
Code
Issues
Pull requests
Actions
Projects
Security and quality
Insights
More
items
Files
Expand file tree
master
Breadcrumbs
MongoDB
/
MongoDB_CRUD.sql
Copy path
Blame
More file actions
Blame
More file actions
Latest commit
History
History
History
177 lines (159 loc) · 4.14 KB
master
Breadcrumbs
MongoDB
/
MongoDB_CRUD.sql
Copy path
Top
File metadata and controls
Code
Blame
177 lines (159 loc) · 4.14 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
--
7.0.3
db
.
createCollection
(
'
tbl_cib
'
)
db
.
tbl_cib
.insertOne({name:
"
Devesh
"
, age:
44
})
db
.
tbl_cib
.insertMany([{name:
"
Devesh
"
, age:
44
}, {name:
"
Madhu
"
, age:
44
}])
db
.
tbl_cib
.bulkWrite([
{ insertOne : { document : { name:
"
Devesh
"
, age:
25
} } },
{ updateOne : { filter : { name:
"
Madhu
"
},
update
: { $
set
: { age:
40
} } } },
{ deleteOne : { filter : { name:
"
Manish
"
} } }
])
--
To Create Collection In Specfic Database
>
show collections
>
use Mongodb_1
/*
switched to db Mongodb_1
*/
>
db
.
createCollection
(
"
table_1
"
)
/*
{ "ok" : 1 }
*/
>
show collections
/*
table_1
*/
>
db
.
createCollection
(
"
table_2
"
,{capped : true, size :
6142800
, max :
10000
})
/*
{ "ok" : 1 }
*/
>
show collections
/*
table_1
table_2
*/
>
db
.
getCollectionNames
()
/*
[ "table_1", "table_2" ]
*/
--
To Drop the Collection
>
db
.
table_2
.drop()
/*
true
*/
>
db
.
getCollectionNames
()
/*
[ "table_1" ]
*/
>
show collections
/*
table_1
*/
--
To insert document into collection
>
db
.
table_1
.insert({
"
C_1
"
:
"
a
"
,
"
C_2
"
:
"
b
"
})
/*
WriteResult({ "nInserted" : 1 })
*/
>
db
.
table_1
.insert({col_1 :
'
test
'
})
/*
WriteResult({ "nInserted" : 1 })
*/
>
db
.
table_1
.insert([{col_1 :
'
test5
'
},{C_1 :
'
a
'
, C_2 :
'
b
'
, col_1 :
'
abc
'
}])
/*
BulkWriteResult({
"writeErrors" : [ ],
"writeConcernErrors" : [ ],
"nInserted" : 2,
"nUpserted" : 0,
"nMatched" : 0,
"nModified" : 0,
"nRemoved" : 0,
"upserted" : [ ]
})
*/
>
db
.
table_1
.save([{col_1 :
'
test5
'
},{C_1 :
'
a
'
, C_2 :
'
b
'
, col_1 :
'
abc
'
}])
/*
BulkWriteResult({
"writeErrors" : [ ],
"writeConcernErrors" : [ ],
"nInserted" : 2,
"nUpserted" : 0,
"nMatched" : 0,
"nModified" : 0,
"nRemoved" : 0,
"upserted" : [ ]
})
*/
>
db
.
post_data
.insert([
{
c1:
'
MongoDB
'
,
c2:
'
MongoDB is no sql database
'
,
c3:
'
unidev point
'
,
c4:
'
unidev39@gamil.com
'
,
c5: [
'
mongodb
'
,
'
database
'
,
'
NoSQL
'
],
c6:
100
},
{
c1:
'
NoSQL Database
'
,
c2:
"
NoSQL database doesn't have tables
"
,
c3:
'
unidev point
'
,
c4:
'
unidev39@gamil.com
'
,
c5: [
'
mongodb
'
,
'
database
'
,
'
NoSQL
'
],
c6:
20
,
comments: [
{
user:
'
unidev
'
,
message:
'
My first comment
'
,
dateCreated: new
Date
(
2019
,
04
,
22
,
2
,
35
),
like
:
0
}
]
}
])
/*
BulkWriteResult({
"writeErrors" : [ ],
"writeConcernErrors" : [ ],
"nInserted" : 2,
"nUpserted" : 0,
"nMatched" : 0,
"nModified" : 0,
"nRemoved" : 0,
"upserted" : [ ]
})
*/
--
Select Query Document
>
db
.
table_1
.find()
/*
{ "_id" : ObjectId("5cbd7a897dd02a3502ab7d90"), "C_1" : "a", "C_2" : "b" }
{ "_id" : ObjectId("5cbe8117418d1db16ec9db0f"), "col_1" : "test" }
{ "_id" : ObjectId("5cbe8248418d1db16ec9db13"), "C_1" : "a", "C_2" : "b", "col_1" : "abc" }
{ "_id" : ObjectId("5cbe82ca418d1db16ec9db15"), "col_1" : "test5" }
{ "_id" : ObjectId("5cbe82ca418d1db16ec9db16"), "C_1" : "a", "C_2" : "b", "col_1" : "abc" }
*/
>
db
.
table_1
.find().pretty()
/*
{ "_id" : ObjectId("5cbd7a897dd02a3502ab7d90"), "C_1" : "a", "C_2" : "b" }
{ "_id" : ObjectId("5cbe8117418d1db16ec9db0f"), "col_1" : "test" }
{
"_id" : ObjectId("5cbe8248418d1db16ec9db13"),
"C_1" : "a",
"C_2" : "b",
"col_1" : "abc"
}
{ "_id" : ObjectId("5cbe82ca418d1db16ec9db15"), "col_1" : "test5" }
{
"_id" : ObjectId("5cbe82ca418d1db16ec9db16"),
"C_1" : "a",
"C_2" : "b",
"col_1" : "abc"
}
*/
cursor
=
db
.
post_data
.find();
while (
cursor
.
hasNext
() ) {
printjson(
cursor
.
next
() );
}
--
-------------------------------------------
--
Update the relevant collection
>
db.
<
relevant_collection_name
>
.updateOne({name:
"
<relevant_user_name
"
},{$
set
:{pwd:
"
<relevant_password>
"
}})
>
db.
<
relevant_collection_name
>
.updateOne({name:
"
<relevant_user_name
"
},{$
set
:{lockedAccountByMultiTry:false}})
>
db.
<
relevant_collection_name
>
.updateOne({name:
"
<relevant_user_name
"
},{$
set
:{passwordExpiryDate:
"
<releavnt_date>
"
}})
>
exit
You can’t perform that action at this time.
