python接続mysql

from APItest.common.config import *
import pymysql

#   pymysql      
mysql = pymysql.connect(host=handle.cp.get('db', 'host'),
                        port=handle.cp.getint('db', 'port'),
                        user=handle.cp.get('db', 'user'),
                        password=handle.cp.get('db', 'pwd'),
                        charset='utf8',
                        autocommit=True)

#             ，     
# 1，       
mysql1 = pymysql.connect(host=handle.cp.get('db', 'host'),
                         port=handle.cp.getint('db', 'port'),
                         user=handle.cp.get('db', 'user'),
                         password=handle.cp.get('db', 'pwd'),
                         charset='utf8',
                         autocommit=True,
                         cursorclass='DictCursor')
# 2,        
cursor = mysql.cursor(pymysql.cursors.DictCursor)

#         
cursor2 = mysql.cursor()  #     ，      ,           ，       
#   sql
sql = "select MAX(MobilePhone) from future.member where MobilePhone like  '135%'"
sql1 = "select * from future.member where MobilePhone like  '135%'"
#   sql
cursor.execute(sql1)
#   ,    
max_phone = cursor.fetchone()  #             ,    
max_phone2 = cursor.fetchone()
print(max_phone)
print(max_phone2)

#        ,    
all_data = cursor.fetchall()     #            ，fetchne     ，fetchall            
print(all_data)

#       
cursor.close()
#     
mysql.close()

転載先:https://www.cnblogs.com/yago/p/11443720.html