SPS
Date:
in Page No
(Casandna DB
CREATE Quoy
Queoy
end table )
CREATE KEY/PACE 1f NOT EXIUT mhlbyee
CREATE TABLE 1f NOT EX1/T enloee-ddan
yo char 50)
'nane
depetmert" chon
4oble be óp olbwn;
enployce _id ngme pday
Abice Mokdiny J0000
2Jane HR
VELECT Quey 10 peled all olumn am the dab le we
(amirond)
/ELECT * fRoM emjloyee
will othn all hows and col 1tom ihe emyee
tuble)
SPS
Date:
Page No
nloye -fd
t0 000
J6ne HR 62. 060
add data to teble)
iNSERT LNTO enhloy ee enmployee_id neme, dopujnat Dal ohe
VALVEJ 3 '8ob'HR650o* J
name dehorment
Alie 0000
Jane HR 62000
65000
Bob HR
Ipod to the
able )
ELECT nplbee id name FROM enloyee*1J
Alice
2 Jane
3 Bob
SPS
Date:
Page No
CoUNNT UM Av4, MÍN MÉ.
(onoider the folluing tuble i
name dept
4 John ÎT HO000
HR 65000
Jane
Bob 1T 2000
3
41 CoUNT:
VELECT (UNTB) FROM enjhoy ee;
Count
3
B)
Duhut:
Dyotom. un |pd thy
Q07000
Date:
-SPS
Page No.
VeLECT Av4 |pda) fAoM enploce
69000ettka
JELECT MINaloy fRoM emplyee
65000
e) MAX
2000
SPS
Date
Page No.
Databue olkcion, and Docunent
Databape (olle tin and documerd
(piltout thm yu e at cble toooe dota on the
A4 dab aoe (antaing a olle dion
documonto nd the dounets ontin dota
Gritetfor alletioA
Doeumen Dottumen
botumnt DocOufhen
1) ommundo) for Dat abaoe
DB pehve e wi the
|Ohow db)
Jalahole rneme
Date: -SPS
Page No.
i Commano fon olle don -
doa boo attsed allo wod fo otoe malipl
bllecioryd
the t (olle cHon io Created win
db. colle disn _num. inaort Dnekey: VvalheJ
hee inntone, io wal to ploe dda
in ,a aheied ollecbn
db. Aulho,inoent onelname "Ankila"
nome -Ankt Ja
y
Autho
DB theo dioamentale eheated
Ky1ivaluet
Ke2 : vdue 2
SPS
Date:I
Page No.
db.iyatudert Daa, innontone
neme "Rokil"
oll: 21
: Lo20
b\onh CIE"
Rohit'
in the alle din naned 'mypdnt t'da
CRUO oherims
( ’ (REA TE
UPDATE
DELETE
CREATE Gomnnd
mothed | tomhond) deocipion
it io uped to inoe a docaument
db. (alledin.insetnel)
db. (alle diorn,inpotMny]
it to uod to (neste an embty colletion
db. (reste ollecion neme
-SPS
Date
Page No.
cledisn.inontke;
vabveJ)JE,
db. otudent, inaot one l
n&me "VumtTt
: 20
6hnch:"CVE"
Made
e: Vuni
fe : 20
bhanch:" CèE"
nane: Rohi
bhonch: "1T"
-SPS
Date:
Page No.
b i READ Cohand
melhod deshiplioM
|db. olle diw. indl ) doc umono
fom the (olle iorn
o en, În þheyíoua tal pludt lolle din
db.ahudend. lindlage2})
name: "umit" ae :20 bhondi"C/
obute
íü) VPD TE (ommand
melho d den (ipHion
db. olle Cin.update One)
bolletisA, thdae doumont in the colle dfion h oaly,
the ivoe chiteja
db. ollecdion. uhd ate Manyyi to used to update nolliple
do Cuments in the colle din thal Dahoy
he qiven Citori
db. (olle Gin. ngplace Oney
n the ol echion that phoy the
fiven
SPS
Date
Page No
in phey audnt ollecdin
the
ptdnt
urder 'ptuder' olle dionto 26.
0ne
Muni
i thne fa aroy douamentih nsme Mi
haplee tht whale
Roho.
SPS
Date:
Page No.
iv Dlde (anmand
mottd des citlin
db. alle din. del ete one U it io uogl to delete 6 pingle
decomen em he Colle dion Iha
Oifeia
documota the Colletian tho
Citehía
I delete one
i wfll delee dl he douament fom olle cisn >
