PYTHON-mysql fetchall和 fetchone之間的區別

標籤：

[[email protected]_server ~]# cat aa.py
import MySQLdb
conn=MySQLdb.connect(host=‘ip‘,user=‘xxx‘,passwd=‘xxx‘,port=xxx,db=‘xxxx‘,charset=‘utf8‘)
cursor =conn.cursor()
sql2="select ip,username,password FROM xxx.xxx"

cursor.execute(sql2)
conn.commit()
row=cursor.fetchall()
for i in row:
print i
[[email protected]_server ~]# cat bb.py
import MySQLdb
conn=MySQLdb.connect(host=‘ip‘,user=‘xxx‘,passwd=‘xxx‘,port=xxx,db=‘xxxx‘,charset=‘utf8‘)
cursor =conn.cursor()
sql2="select ip,username,password FROM xxx.xxx"

cursor.execute(sql2)
conn.commit()
row=cursor.fetchone()
for i in row:
print i

 

 

[[email protected]_server ~]# python bb.py
192.168.X.X
XXX
XXX
[[email protected]_server ~]# python aa.py
(u‘192.168.X.X1‘, u‘XXX‘, u‘XXX‘)
(u‘192.168.X.X2‘, u‘XXX‘, u‘XXX‘)
(u‘192.168.X.X3‘, u‘XXX‘, u‘XXX‘)

PYTHON-mysql fetchall和 fetchone之間的區別