PYTHON CƠ BẢN - RẤT LÀ CƠ BẢN - Trang 69

import MySQLdb

db

=

MySQLdb.connect(...)

cursor

=

db.cursor()

cursor.close()
db.close()

4VITEVIH7XEXIQIRX

4VITEVIHWXEXIQIRXPɧOцXLYϼXXLEQWРLɹEGɨGHоPMЖY
XVY]АRZɧSGɩYXVY]ZϴRXLE]ZɳRРMGLYЦMXVрGXMЎTчВ\ɩ]
HрRKQШXGLYЦMXVY]ZϴRHɧM/цXLYϼXRɧ]чšвGɨTHдRK
RLMАYZɧKMɾTXʆRKLMЖYUYϲZɧXɴRLFϲSQϼXGжEGɩYXVY]
ZϴR:ɴHд

...
cur.execute(

"UPDATE Writers SET Name = %s WHERE Id

= %s"

, (

"John"

,

"4"

))

...

1ЦMXLEQWРXVY]ZϴRWЌчšвGXLE]XLЎFЀRK

%s

ZɧTLš˜RK

XLиG

execute()

WЌGɹXLEQWРXLиPɧQШX8YTPIGɹKMɨXVК