[go: up one dir, main page]
Scribd
Upload
396 views5 pages

11 Ip Mysql Handwritten Notes 1

SQL notes

Uploaded by

Priti Singhal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
396 views5 pages

11 Ip Mysql Handwritten Notes 1

SQL notes

Uploaded by

Priti Singhal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
You are on page 1/ 5
inbennm A-€ (eau) (Geuctured Quy bengase) meee = SepRAONE Create a now Gatabase + Mywl> Create databax Schorr, ; d 5 nama the ees ant open. / Moke cwrnt — dakobor Lise Achevt, Adual gota o stored 4 tebles ables one wrt m dalobae Crentrg, a now able (eg student) t= nt String Note: — T Create. table shuolent Sn © admnd int prim kegs }2. xu Tame Vanchan (18) not Muh, Class ine, Aw ches (!), Atrean —— Vanoher (20) 2 ‘ 7 Le abr Cgpwmwanrd pill Crcott He atruchur (Schoo) Hf the fbb Student fo Vied — fhe Atrudas A feo table ; a ees i desc Student; ov duovihe student 5 Te_Gnset [add records yn de table (zaweer wT -) Insert into Student Values (G23 a8 Aran, Wet", “gene” Keno thor ie —_——__ Q Ingert ynrte Shidont (rome, adn , stream, Chass , sec) ‘ 14? » 5 values ( * Ruksta 7 B56F , © Commerce’, 25d) Dicploging the rterds from He Yate ( SELECT) 4 To aeplog ok records amd all column meat all cous Select Fron students; Te disor Aalaked [Arete calumas Selec ow ass 4pm gtident ; specs columns Bo be Uiplaged form eu; c be ig it ee >) A ae the hae 4. Cccpeig. Calies nanre) Select name fe “stuclont name , CAaw, sbicam from Student; alos name oy ne headend. av column, Name PE hadnt Nowe, mee Select ¥ eo Stunt ; > will dais lo oh re usrds Sele Stic ony or where galnno = 5564 , > nil display veear dh pu col [Arr adiany = 5567 on Shicleut- will dicplay few = Ils “9 den n Grd tere yrereas| Select — Sname pew Stuoleut rhe hous 2 II 5 Lip pe Meee, adan Y Selec ke re Student whee SH = “science” 5 Select pon Shidemt where ctream > © humanitia” Hosa ore dior Gre cond. lame i went 7% > — The foe Sain

You might also like