2019独角兽企业重金招聘Python工程师标准>>> 
#!/usr/bin/python
# -*- coding: UTF-8 -*-
import pymysql
from openpyxl import load_workbook
# sql=" select * from saas_school_type where schoolId=3408260001 "
updateSql=" update saas_school_type set customerService=%s where schoolId=%s "
db = pymysql.connect(host = 'rdsmrrjuqmrrjuq758.mysql.rds.aliyuncs.com', port = 3268, user = 'zl_cicada', passwd = '04zHiliao_01', db = 'kidscare', charset="utf8")
cursor = db.cursor()
# cursor.execute(sql)
# sqlList = cursor.fetchone()
# print(sqlList[0])
wb = load_workbook(filename='/Users/chanming/Desktop/园所匹配客成-1219.xlsx', read_only=True)
ws = wb['Sheet1']
sn={}
for row in ws.rows:
sn[row[0].value]=row[2].value
for key,value in sn.items():
print(key),
print(value)
cursor.execute(updateSql,(value,key))
db.commit()
cursor.close()
db.close()