Python连接Mysql数据库

#codin=utf-8
import pymysql

def db(StrSql):
    db=pymysql.connect("ip地址","账号","密码","库名")

    cursor=db.cursor()

    cursor.execute(StrSql)

    data=cursor.fetchall();

    db.commit()
    db.close()

    return  data;
    pass

# if __name__ == '__main__':
#
#     print(db("""INSERT INTO express (exname,excode)VALUES("1","2")"""))
#
#     pass