Tntereface lython itl My SoL
2.
.
To CHuate
Ptlon
MysoL
a roject,
IDLE
you need thee sofoare
3.
ython MysoL Comectorn
To cheate datakase conmecitwty between lytteon
Qnd my soL, we neod do install PPylen
IDLE andd my soL Conmec toh:
MysoL Commec tor comect Rhon wile MysOL
the data yom PyAhon as front-end
and mysoL as backend
PIP> y 9L Comneton ston ds zon Petenued
PIP alloas wses to install jackages fomn
the Rtlon lackage inclex, koned
Essential Amction% durng patabase Connec tiuity
Connect c) ue
Connect Rytton and ay soL
comnection_ cbject = myl. commeclon, lomect(host =
local host"
pesuod
olatabasc
is useot to
Cuhson) Tuis metod
cunbor Object Aesponslble hon
Cheate
statements
to Communicat Lwill
execuctin9
cmnection byet.
cunboh cbject
to exe ute
Tis mnotuod is used
executec)
SAL statamant 4Oitten in Rytlon IDLE:
4htax comecton-obje ct eneute (Oue;
4 formatC Lis metaod fomats
tn
e spe ited
strn
at
ualues
its bosition,
and tosent
blace holdeh . TLa
o Hue
placeholden
|s defihodwsing ? cunly kzcket braces.
Syntax ting. fonmat (valel,walue?,)
Aoocont)
more tie
object to dete
the etuns
Tus gies us te contng o the total
nombe in Hue
executbon 9 te Statemnt.
CuhSOM objet, Mocountl)
my SOL-Connechon, commit)
Comit o le
sehds a com mI Statemont
method
MysaL sehneh com mtting te cutont thrg
has ampletd exeutng
to he db, calL commto nchod
oueney wite ehonges
hollback MysoL Connecbonho llback
euents te changes made by Me
cuten thansacthon'
auto commit
8. Auto Com mit Dys0L Con necton.
Thue oh falbe
ualue Can be
astigned false
ualue is
Bydfaul its
totuocg Data pkom Database
data hom the olata base) table
6 exte.a ct
qre thee suicions puoucdad by yHuon
fethono)- It fetches the nekt aw
set
9 uey Heselt
Tis matod tetelo' kingle KecOndem
data base tablo.
fetches ne aOnd at a timeog
luhboh,
FeteuallC) feteues all hes deta' foong
the cuboh.
haue aleady been entatiel
yhon tthe esult set, thoy it setrieves
Vtte
ttnain
set
3
etele
hboh object.
Letches qiuen
more
ttion ows auailable in table
it etirHns all
nUm.
feehone
Con = C comect Chost= "oalhest',
passd=
olatabase =
CUhbOh = on, cuhsohC)
CuhsOh, exeete"select * tong em
pecOnd cuhsOpetthonec)
brint e cand )
Fetchall
impont mysql. comectan esc
Con = C, con nect (host = localhos t eh 'Hoot
data base
pass od
Cusboh = cen, UhsonC
usOh, ere Ey "select
econc=
Hint" Toal la, no cohols"
Fetclomen
C. Con nect host= loca lhas ta
Con =
dataBese =
cunsOn com, CunsOp )
oloct seog. emp'
cunson, execul (Quel
data ,
= cu nson fetelmay)
Data base
Koo to Ckaato tWlla thogl ploy ireaace
impant
Con
my8ql
C.Connect
com
(
necton
host=
bassuind-
as
"localhos t"
"/23y'")
Cuh con, cunson)
"Cheate database tudon t"
Cun, eyoecutel QulY)
Done Batabase cucatod)
blent
on. com mt)
wse tlat datatase studont"
imponi msql.cogmetor
C. Comeet "local hOst
host uyeH= "poot
bassuond= "/2.34 olata base=
con, cHBOrl)
CHate table studont dtails(
RolL Ao int phemauy key
Alaome uaHchatn(oo
manks loat(42)
cun.exeuite( Query)
bunt " Table Choate')
Con, commit)
Can check database
black wimdloo chock at
windlou.
desc command jetel ce able
stutra ion cle
tuple
tatle Atuctahe tn lylorn
Moo to show
ab c
tmpon mysgl, connedoh
wsdh= poot
Con= c,comnect (host = localhost
passuso hd"2.34!
=
data base "studant!
Cuhz Con, cuhBOh ()
desc stutont dotails
cuh ,eoe ute (auY)
Qubpet
Griues table stuctue
Con, cOmmit
Houw to
to mseht data Xong petn in le fable.
mport 'mysgl,commectot as c
Con = C, Conmect (host= lgcalAos t
tse=Msot" y2.341
passwoHol
olatalase = "suclont
Cúh Com, cuhsO)
(nsent into studentoletaels alues
lol, Rars S.Do)
Ros to nsent multiplo alues .
= "localhost 'oat'
Con = C. Connect host ues
pasusDtbd = "1234"
database "studnt)
Com, ch60b)
Loile Teei lo=)
nput En ton Roll
Roll Alo= bnt
Mame = input (Enton
Mame )
"Erith Manks-)
Man kz = tloat (inpe
"iMsent nto ca sudntdetails
ualues(i?,'s?£ ?)"fomat
Roll No,Alame, Mak
eus,exeete (auey)
Com, co Mmit )
