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

OMВY

Dictionary

XLɳGɹXLВOLEMFɨS

import MySQLdb

db

=

MySQLdb.connect(host

=

'localhost'

, user

=

'ro

ot'

, passwd

=

'root'

, db

=

'mysql'

)

cursor

=

db.cursor(MySQLdb.cursors.DictCursor)

...

*IXGLHоPMЖY

'ɹQШXWРGɨGLчВJIXGLHоPMЖYXLɺRKHдRKXк

cursor

WEY

OLMчɪ

exectute(sql)

Pɧ

fetchone()

Zɧ

fetchall()

fetchone()

GLИJIXGLQШXHɸRKHоPMЖY2ЎYQYРR

JIXGLRLMАYHɸRKHоPMЖYXLɳGɹXLВKМMRLMАYP϶RQЦM
P϶RWЌXVϲZАQШXHɸRKHоPMЖY8РXGLSXVšЬRKLвTXVY]
ZϴRVϴXRLMАYHоPMЖYQШXPɾG2ЎYXVϲZА

None

XиGPɧ

чɪJIXGLLЎXHоPMЖYXкGɩYXVY]ZϴR

fetchall()

JIXGLXSɧRFШHоPMЖYXVY]ZϴRчšвGXк

GɩYXVY]ZϴRZɧXVϲZАQШXXYTPIGLиEGɨGHɸRKHо