python - 如何使用带有 for 或 while 循环的 MySQLdb SELECT

Question

import _mysql as mysql
db=mysql.connect('localhost','username','password','database')


db.query("""select * from news""")

result = db.store_result()


print result.num_rows()#two records

#how to loop? without cursor

print result.fetch_row()

Answer 1

你可以试试这个:

while True:
    record = result.fetch_row()
    if not record: break
    print record

我第二@Ignacio的 note of caution反对使用 _mysql。切换到import MySQLdb。