我有一个MySql查询,一切正常,但我想制作一个数组,将每一行用于查询
这是我的代码:
db = MySQLdb.connect(host="127.0.0.1", user="root", passwd="", db="seliso")
cursor = db.cursor()
cursor.execute("SELECT * FROM usuarios WHERE contador = " + "'" + userContador + "'")
results = cursor.fetchall()
for row in results:
rfc = row[1]
clave = row[2]
我想做的例子:
db = MySQLdb.connect(host="127.0.0.1", user="root", passwd="", db="seliso")
cursor = db.cursor()
cursor.execute("SELECT * FROM usuarios WHERE contador = " + "'" + userContador + "'")
results = cursor.fetchall()
for row in results:
rfc = row[1]
clave = row[2]
$arrayRFC = ["rfc1", "rfc2", "rfc3"]
$arrayClave = ["clave1", "clave2", "clave3"]
如何实现这一点?
提前谢谢。
你可以通过以下方式获得它:
for i in zip(*results):
print(list(i))
此外,出于 SQL 注入的原因,不应使用这样的字符串串联。而是做:
cursor.execute("SELECT * FROM usuarios WHERE contador = %s",(userContador,))
其中%s
是参数样式: http://mysql-python.sourceforge.net/MySQLdb.html