首頁猿問如下內(nèi)容，請問需要怎樣才能用fet...

如下內(nèi)容，請問需要怎樣才能用fetchall方法，要其它數(shù)據(jù)類型作過渡么？謝謝

Python

慕無忌1623718 2022-10-20 15:15:37

python中，mysql數(shù)據(jù)庫中查詢結(jié)果用下列語句賦值給cursor變量cursor=con.execute('select * from test')然后用下面語句取出所有查詢結(jié)果并賦值給rowsrows=cursor.fetchall（）結(jié)果報錯如下AttributeError: 'long' object has no attribute 'fetchall'請問cursor是什么數(shù)據(jù)類型，不能直接使用fetchall（）方法么？

查看完整描述

3 回答

Helenr

TA貢獻1780條經(jīng)驗獲得超4個贊

conn = connectDB() # "oceantest"
with conn.cursor() as cursor:
sql = "select * from test limit 10" # 在test表中取出十條數(shù)據(jù)
search_count = cursor.execute(sql)
result = cursor.fetchall()

反對回復(fù) 2022-10-24

慕村9548890

TA貢獻1884條經(jīng)驗獲得超4個贊

def getallinfo(x,y):
#x為數(shù)據(jù)庫，y為sql
coon=pymysql.connect(user='root',passwd='123456',db=x,port=3306,host='127.0.0.1',charset='utf8')
cursor=coon.cursor()
cursor.execute(y)
res=cursor.fetchall()
cursor.close()
coon.close()
return res

反對回復(fù) 2022-10-24

ibeautiful

TA貢獻1993條經(jīng)驗獲得超6個贊

你這是用python來執(zhí)行數(shù)據(jù)庫查看的操作吧
import pymysql
conn = pymysql.connect(user ='root',password ='你的密碼',db = 'test所在的庫')
cursor = conn.cursor()
count = cursor.execute('select * from test')
data = cursor.fetchall
print(data)

反對回復(fù) 2022-10-24