我想用Python语言从MySQL中取出多行,每行放入一个字符串.
mycursor.execute("SELECT ProductName FROM products ;")
if mycursor.rowcount == 0:
products = "No Products."
else:
products = ""
for row in mycursor.fetchall():
products += "{ProductName} ".format(**row)
对于上面的代码,我得到了下面的错误:
str.format() argument after ** must be a mapping, not tuple个