Scribd
Upload
5 views6 pages

Python

python class notes

Uploaded by

kumar04prakhar
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
5 views6 pages

Python

python class notes

Uploaded by

kumar04prakhar
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/ 6
1, ‘arr- A fuera tAKA 1.) Waite Python Prognam do perfonm olla wire data Q) Cwecte a table EMP TRATNING With Finst_ Name, Last NAME, AGE GENDER and INCOME ) Set Connection with mysql - Connector Connect . ©) Change Jable SPuctuie / (add. edit, Memove Columa of a toble ) ak sun time. L) add a Column addsess un the &mP_TRainiNci table ih) Updates all the sezords having GIENDEE O84) 04 Lincuease Awe 4 all the male by one yeax iv) dleleke Tall the Secords juom £uP_Teamindr Table where Aue ws bess than 18 Ass dmpouk Hysqe - Connector AE funchion do wueste EMP Tenner Table ole, unset — Secord (Gws0¢, Heeord) : Cussor. execute (CaNerer INTO EMP_. TRAENING (frest_wome » LAST_NAME, AGE, GenDER »TNCO ao Vawuts (US57.S, 45. 4S, $5)", Stecord ) Cunsor Connection. Commit () HE function Jo update siecords in Eup_ TRAININ da subdate = Seeords ( Cnsor) + Update steeord (cumsor >) dabte HDelele Mocords ‘on ENP_ TRAINING doble where oe us des than Ss Seeorels ( Cursor ) except musgl: Connector . Gur a4 Leer prent (‘Prited to Connect te "y Sa database :'", a) inal 4 eels is — Connected ( >! Cwuor. close () Connection . Chose ( ) Python ictewting absignenant (10 ynorks ) The aasignment: Heques chow puopram Client dnd, Auiser) in Fitton, that impsemert the ie dacnited below Abt nosh pat have do be dent /cccied Usig the TEP. Polat ns: Import Socket import Stondom 3 hharclte —clent (client Socket) : Cursor. exceute ("OCLETE fro Rup panne wkeee Agit

You might also like