-
Notifications
You must be signed in to change notification settings - Fork 9
/
MONGO.txt
77 lines (74 loc) · 2.78 KB
/
MONGO.txt
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
Mongodb:-
----------------
Database :- Mysql,sqlserver,Oracle -structured database (rows and columns)
Mongodb,cacendra :- unstructured database.Data will be in form of document.
*company which use it are *facebook,paytm,etc..
1)mongodb is a cross-platform ,document oriented base,high performance,easy scalability.
2)mongodb works on concept of collection and document.
------------------------------------------------------------------------------------
RDBMS Mongodb
-------------------------------------------------------------------
Table collection
database database
Tuple/row document
column field
table join embedded document
PrimaryKey default key_id provided by mongodb itself
-------------------------------------------------------------------------------------------------------
3)document :- it is a set of key-value pairs.
4)collection is a group of mongodb document.
----------------------------------------------------------------
example of a collection
-----------------------------------
comment:
[
{
user:"Koyel",
message:"Good Morning",
dateCreated: new Date(2018,15,1,12,20),
like:120
},
{
user:"Aritra",
message:"Good Morning",
dateCreated: new Date(2018,15,1,12,20),
like:125
}
]
---------------------------------------------------------------------------
www.mongodb.org official website.
---------------------------------------------------------------------------
CREATE FOLDER :- C:\data\db
---------------------------------------------------
1)to view database
show databases;
show dbs;
----------------------------------------------
2)to create database
use wiprostudents;
-------------------------------------------------------
3)to show no of tables
show tables;
show collections;
---------------------------------------------------------
4)to see the database in which you are working
db;
------------------------------------------------------------
5)to create table/collection
db.createCollection('student');
---------------------------------------------------------------
6)to insert data into student
db.student.insert({name:'Koyel',email:'[email protected]',username:'koyel',password:'1234'});
--------------------------------------------------------------------------------------
7)to view the rows/document
db.student.find();
--------------------------------------------------------
8)to view the rows/document in a proper order
db.student.find().pretty();
---------------------------------------------------------
9)to update the document
db.student.update({email:'[email protected]'},{$set:{password:'sunil@1'}});
----------------------------------------------------------------------
10)to delete the document
db.student.remove({username:'susmita'});
----------------------------------------------------------------