I

Y22 11502811-
ECE -·-n
 -

~ ----- fvt¼1t,l-~ o l
~~

<> ~½
~
V w~ ~ ¾f
~Ri ~
~
~N~~~
0N\--1 L ~ ~ ~ iMJv ~~~ 'he\,~,

ui.~ ,~ Nv.ut{ ~ .
2-) E-Mtv ~ ~-00 ~ rrvw ~ ~ W~Ll
VN();)~ ~ Mt 1~
2) 0.wvw, ~ 0 MM ~ ~" .
½) Gi°'JvY\V Cl ~ ~ ~ -t~ C~tl<),t tvvwl
~) ~ ~ ~ ~UlA{, -
 ~
r -..1, :i " .
tlu

,_____,__ ·1 ---
- ..,.
I
j

\ -+-f lt,,~

J J ~ , M , y v CVp ~ ~~)
QL,\_LJ el - 8Z,
~:
~ ~~
~ ~
-
'n M , \ , { /
~\J
~
1) ~~~ ~ ~
v ¼.d
~ u t i f k t0,1 '
~
(/2~/
~ ~ ) 1,:t('.,v, °"\Al_ )
~J
~ \ t l . J 1,0~,L

2J ~ ~ ~ -
h
to
v c,t, ~ ~ d;U, (,1 J
. b,~
~l
1

w.t Covvv l: t4 t ~ ,vq J. Vv\

L-~
j
kw ~
/;¼ I V \ / ~
. V
0-f--~
• lr\i.,,f~A-~
e,,A., vl4 Ll\,'j -f: )?1,"ioit~
f Ovf:
~ OJv, ~
~ < l
J) J'~ ~
,' !;0J. ::'~,,."·' ' ~
.
,_ .,.. '\ '
\
'
.., ..,,,
·r r- •
•
,' t
.. .,,.;.-~
"' ' /
-··
 -

-·
'
••
.
, -- · -~~ -
.
---- +•• - ,
lb
 EXPERIMENT-2

AIM Je tudy DLL COmmands m SGL

THEORY
nd kniu
Suciuud Su Lamgung L ) a
-thew hich he
the antabas naun4
databas
Ow the ixtm
Cam PLem COAtAm Cptatued
aloe he Cam PUULotm CUtawv epuAtns Pn
Omd
mma albe n COM
eLxXIAUma dhotab aML
n d also ne Cam
ww.g to ul database
CLat 0 datab ase. SgL ua
U thw lamauuye to
Cta COnmamds k d
Citatu, diep
Atgnid tauks
Cau u t t h
to CaA
wU
Commamds A naunby CallyeAZid
A A SYL
ow Cattgosius a

Dala 0Dinitow kamguase

DLL
ar Manipulainen lamguage
. DML
Dat Ul iAmauage
DSL Datn Centhel lanamai
DCL

DDL (DlA Ddiiew lanuase)

cOwiMs
DDL O Dat Del initen lauguage actally
the s8L Conimmandy thal Corw wtd to Atlme the
 ntabas AchivMA
DDL
COmnnAM
CREATE J
td to) tat
DROP dalala.
dalalase ud
L u cd to dilple ud hom
dutaba
ALTER u wd to al e udw Lhddalar
TAUNCATE Uded to mive all iunnds hen
AEL heludug al Jatt ocatl hs

COMMENT -
a t dd commanty to he dalas

AcDeni
y we to mame A DK ixita
REN AME
w atabnre
JableN am Studt

BAameh Smutu ReNO. GAndw

ECE 02 A

CSE A

EC 08 A
IT
4U A
Kati ECE 20 A
 Sulty to cheate take

yntay
ate able tablename column datotpe
Column2 datobype
Cmn 3 datatyp
CPwmand

tale Ctudeut Nanne Pacha10c)

B5anch Vaicha (20)
2.0)
Cemmrlw
RgNo m.b

GhadL ai chai (s)

W sQL Q o de th tablu

SynuoX, op to tal -
A

hudint
mDnd. o P tale

i t e GL 4 y to ada colmn
Addsus "w he

tale- aw ADD ¢plumn -

Atalle

Cntn A t tale u d u t ADD Adas vascha (100

Wi sSL muy to Atlete
AL
data im he talle
tudmt

Sudax uncale lable lable

SuWale lahle udeu
COmmAN

the
the tablu "Ctudtt to usri
Chmge
i U s i l - tudtts
name RENAME TO
lte tasle tabl
Sntax

Ceuwand t e tablu a u a RENAME TO

RESULT
SQL hane Scew tudlid
bDLbDL CwwmAmas
 EXPERIMENT -3
AIM d MnA wwMwMlnA
ln D
nd co@ndihain SOL bML
ML (9wmad
CmwwwAD
THEORY DMLDala Mampulatun lamgunge)
A L CmwandJ Thal dLals wwth
MAAmuipAn
w the dpdabas t t DML
the Sg L atimini
DML
NSERT
PDATE Ard w updati ixutg dat wthn

DELETE d , to dtett Mcnas m dataha

Ja Nai Vte

FNamn L-Nae DOD Aa voth id

Sax Lna Mhi i5-+9-1 26 21

SAa Mudar 18-12-114 2 803

T Pane 31-10-199 21 200
hanma Ned 05-09-90M 20 12
SOL&uuy to insut the dat n e mlotw
SUtax s t mlo all- manni (Couwmm
Valuw valmu J, Valu
Cotnwo
Valute 3, .
V o F-Nam
F-NomL L-Nann
Name
Imtp te
COwtwama
nJNt

Vgtu. d)
ouly,Do8, Age, Nda 05081932
F a l y "SAta, " h a m a

2 3) Agarnial
gavnal
update LNamne
update LName
u t SQL quUn
whe Vetus _
id =31
COLnwn.
table-nAme SET
Sytax Updat
ame 2 o

commm2

WHERE c o n d e n

LNamme Asghial
pdall Voler ET
AwwnAnd

Vt-d =311)
h to delete tho detailo Vøts
N i t e SOL m y
Ptw.
Delede ko talle-nanme wHERE
WHERE
Snk

Vetes wHERE VUtes_d=2g

Porvwandu elett som
Aplay the ddaul Vot wwo Lolong to Delhi
Cmtax Select colmmmmi CAmMm

FROMtablehame WHERE c0ndcuow

OhwMAnd 0w Ve
City
TNULL;
NOTNDlL;
Vaichar
Vchas ( 20) NO
C5Catt table Vetes (F-Nanme NOT NULLS
LName
vachas 20)
"Dellu
Baschas so) AEFA VLT
datc
DOB a)
CHECK (Ae
Ageuuwmbe,
PRIMARY AEY
Vott-d nmbl
a a

t
tuud
d ilAa

RESULT hane
beem
C o m - a n d s

eDML
Auplentid lcustul