python连接SQlServer数据库

import pymssql
connect = pymssql.connect('local', 'sa', '1234', 'aaaa') #服务器名,账户,密码,数据库名
if connect:
    print("连接成功!")
cursor = connect.cursor()
mm="93%"
id="ACADABB1-3109-4BF9-9B19-DD08D466310F"
sql = "update bim.dbo.mlPlatform set map=%s%s%s where cast(ID as varchar(255))=%s%s%s"%("\'",mm,"\'","\'",id,"\'")
cursor.execute(sql)   #执行sql语句
connect.commit()
cursor.close()
connect.close()