pymsql连接mysql

import pymysql

    # 1 连接mysql
conn = pymysql.connect(
    host='127.0.0.1',
    port=3306,
    user='root',
    passwd='123456',
    charset='utf8',
    db='unicom'
)

    # 2 收发指令的手，基于cusor发送指令
    # 不要用字符串格式化做SQL拼接，安全隐患SQL注入
cusor = conn.cursor(cursor=pymysql.cursors.DictCursor)

    # 3 发送指令
	# 字符串形式sql
cusor.execute("insert into admin(username, password,mobile) values('wupeiqi','qwe123','1515555555')")
	
	# 字符串参数，用pymysql内部的占位符做
sql = "insert into admin(username, password,mobile) values(%s, %s, %s)"
cusor.execute(sql,['韩超','qwe123', "19999999999"])
	
	# 字典参数
sql = "insert into admin(username, password,mobile) values(%(n1)s, %(n2)s, %(n3)s)"
cusor.execute(sql,{'n1':'集宁','n2':'qwe123', 'n3':"19999999999"})

	# 提交命令
conn.commit()

    # 4 关闭连接
cusor.close()
conn.close()