python小白紧急求助!
用python获取MySQL的数据,但是奇怪的是用fetchone()成功了,但是fetchall()却失败了,有没有大佬可以解答一下...
//fetchone()
try:
cursor.execute(sql)
results = cursor.fetchall()
for i in results:
print (i+'\n')
except:
print("Error: unable to fecth data")
结果:
错误情况:
//fetchall()
try:
cursor.execute(sql)
results = cursor.fetchone()
for i in results:
print (i+'\n')
except:
print("Error: unable to fecth data")
结果: