Python多变量循环

Question

我试图创建一个for循环来将用户定义的多个关联变量写入数据库，有没有办法这样做？

import sqlite3 as lite
import sys

names = ( "John", "Sal", "Bill" )
ids = ( 123, 321, 231 )

con = lite.connect('test.db')
cur = con.cursor()

**for x in names and y in id:**

  cur.execute("INSERT INTO People(Name, ID) VALUES('%s', %d)" % x y)

Answer 1

要同时遍历多个iterable，请使用zip。

>>> names = ( "John", "Sal", "Bill" )
>>> ids = ( 123, 321, 231 )
>>> for x,y in zip(names, ids):
...     print x,y
...
John 123
Sal 321
Bill 231