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

...
db

=

MySQLdb.connect(host

=

'localhost'

, user

=

'ro

ot'

, passwd

=

'root'

, db

=

'test'

, charset

=

'utf8'

)

5YIV]HоPMЖY

ɇВXVY]ZϴRHоPMЖYGLϰ]GɩYPЖRL750 XLɳWмHдRK

cursor

GжE1]750HF:ɴHд

import MySQLdb

db

=

MySQLdb.connect(host

=

'localhost'

, user

=

'ro

ot'

, passwd

=

'root'

, db

=

'mysql'

)

;

cursor

=

db.cursor()

sql

=

'SELECT * FROM user'

cursor.execute(sql)
myusers

=

cursor.fetchall()

:ɴHдHоPMЖYFMЎR

myusers

((1, 'John'), (2, 'Doe'))

1ІGчКRL

cursor

WЌXVϲZАQЦMHɸRKHоPMЖYXк1]750

XLISOMВY

tuple

XиGPɧOLɺRKGɹOI]2ЎYFϰRQYРRXVϲZА