fetachone和fetchall

def modifyBtn(req,modifyip):
   print modifyip
   conn= MySQLdb.connect(
        host='localhost',
        port = 3306,
        user='root',
        passwd='1234567',
        db ='DEVOPS'
        )
   cur = conn.cursor()
   a = cur.execute("select ip,info,env from machine_info  where ip=%s ",[modifyip])
   info = cur.fetchone()
   print info
   print type(info)
   return render_to_response('cmdb/modifyBtn.html')


System check identified no issues (0 silenced).
December 25, 2017 - 13:04:32
Django version 1.11, using settings 'mysite.settings'
Starting development server at http://0.0.0.0:9000/
Quit the server with CONTROL-C.
1.1.1.1
('1.1.1.1', 'aaa', 'bbb')

fetchone 是一维数组


fetchall是多维数据
def modifyBtn(req,modifyip):
   print modifyip
   conn= MySQLdb.connect(
        host='localhost',
        port = 3306,
        user='root',
        passwd='1234567',
        db ='DEVOPS'
        )
   cur = conn.cursor()
   a = cur.execute("select ip,info,env from machine_info  where ip=%s ",[modifyip])
   info = cur.fetchall()
   print info
   print type(info)
   return render_to_response('cmdb/modifyBtn.html')


Django version 1.11, using settings 'mysite.settings'
Starting development server at http://0.0.0.0:9000/
Quit the server with CONTROL-C.



1.1.1.1
(('1.1.1.1', 'aaa', 'bbb'),)