python中，mysql數(shù)據(jù)庫(kù)中查詢結(jié)果用下列語(yǔ)句賦值給cursor變量cursor=con.execute('select * from test')然后用下面語(yǔ)句取出所有查詢結(jié)果并賦值給rowsrows=cursor.fetchall（）結(jié)果報(bào)錯(cuò)如下AttributeError: 'long' object has no attribute 'fetchall'請(qǐng)問(wèn)cursor是什么數(shù)據(jù)類型，不能直接使用fetchall（）方法么？需要怎樣才能用fetchall方法，要其它數(shù)據(jù)類型作過(guò)渡么？謝謝
3 回答
皈依舞
TA貢獻(xiàn)1851條經(jīng)驗(yàn) 獲得超3個(gè)贊
def getallinfo(x,y):
#x為數(shù)據(jù)庫(kù)，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
絕地?zé)o雙
TA貢獻(xiàn)1946條經(jīng)驗(yàn) 獲得超4個(gè)贊
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()
慕尼黑的夜晚無(wú)繁華
TA貢獻(xiàn)1864條經(jīng)驗(yàn) 獲得超6個(gè)贊
import pymysql
conn = pymysql.connect(user ='root',password ='你的密碼',db = 'test所在的庫(kù)')
cursor = conn.cursor()
count = cursor.execute('select * from test')
data = cursor.fetchall
print(data)
添加回答
舉報(bào)
0/150
提交
取消