python - while 循环中的变量赋值

Question

在 python 中执行上述操作最接近的模式是什么？

while (item=self.cursor.fetchone()):
    print item['id']

基本上，我想获得单个数据库行的结果。执行此操作最直接的方法是什么，或者我是否需要一些通用循环，如 while 1？

Answer 1

关于 MySQLCursor.fetchone() 有一个综合部分文档页面:

The following example shows two equivalent ways to process a query result. The first uses fetchone() in a while loop, the second uses the cursor as an iterator:

# Using a while loop
cursor.execute("SELECT * FROM employees")
row = cursor.fetchone()
while row is not None:
    print(row)
    row = cursor.fetchone()

# Using the cursor as iterator
cursor.execute("SELECT * FROM employees")
for row in cursor:
    print(row)